"Cannot set 'identity_insert', it is already on for a different table. %1"
Item |
Description |
SQLCode
|
-1000294L
|
Constant
|
EMSG_IDENTITY_INSERT_ON_FOR_OTHER
|
SQLState
|
QDC76
|
ODBC 2 State
|
ERROR
|
ODBC 3 State
|
ERROR
|
Sybase Error Code
|
20645
|
Severity Code
|
14
|
Parameter 1
|
location of exception
|
Probable cause
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.