In this blog post, you’ll learn more about the Sybase Error Cannot set ‘identity_insert’, it is already on for a different table. %1 and the reason for receiving this error
Sybase SQL Error Message
Cannot set ‘identity_insert’, it is already on for a different table. %1
Reason for this Error
the set option ‘identity_insert’ can only be set for one table at a time. To set it for a different table, first turn it off using ‘set identity_insert ” ‘ then set it to the desired table.
