Sybase Error – Cannot set ‘identity_insert’, it is already on for a different table. %1

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.