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

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>