"Cannot drop %1 %2: set option 'identity_insert' must be off. "
| Item |
Description |
|
SQLCode
|
-1008037L
|
|
Constant
|
EMSG_IDENTITY_INSERT_IS_ON
|
|
SQLState
|
QNA46
|
|
ODBC 2 State
|
ERROR
|
|
ODBC 3 State
|
ERROR
|
|
Sybase Error Code
|
20643
|
|
Severity Code
|
14
|
|
Parameter 1
|
string literal 'Table' or 'Column'
|
|
Parameter 2
|
column name
|
Probable cause
option 'identity insert' must not be set to any table name to drop an Identity Column. To turn it off use 'set identity_insert '' '