In this blog post, you’ll learn more about the Sybase Error Cannot insert or update Column %2: set option ‘identity_insert’ to the specific table name containing the identity column to be modified. %1 and the reason for receiving this error
Sybase SQL Error Message
Cannot insert or update Column %2: set option ‘identity_insert’ to the specific table name containing the identity column to be modified. %1
Reason for this Error
set option ‘identity_insert’ must be set to the specific table for which you want to insert or update an Identity column. To turn it on use set identity_insert <table_name>
