In this blog post, you’ll learn more about the Sybase Error Cannot drop %1 %2: set option ‘identity_insert’ must be off. and the reason for receiving this error
Sybase SQL Error Message
Cannot drop %1 %2: set option ‘identity_insert’ must be off.
Reason for this Error
option ‘identity insert’ must not be set to any table name to drop an Identity Column. To turn it off use ‘set identity_insert ” ‘
