"Cannot insert or update Column %2: set option 'identity_insert' to the specific table name containing the identity column to be modified. %1"
| Item |
Description |
|
SQLCode
|
-1000293L
|
|
Constant
|
EMSG_IDENTITY_INSERT_IS_OFF
|
|
SQLState
|
QDC75
|
|
ODBC 2 State
|
ERROR
|
|
ODBC 3 State
|
ERROR
|
|
Sybase Error Code
|
20644
|
|
Severity Code
|
14
|
|
Parameter 1
|
location of exception
|
|
Parameter 2
|
column name
|
Probable cause
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>