1
Answer

how to off identity insert

Ask a question
Abdu Rafeeq

Abdu Rafeeq

13y
2.1k
1

 i tried to off identity insert by given syntax for copy the values

SET IDENTITY_INSERT tblName OFF

but iam failed to off

i got message

"

An explicit value for the identity column in table Dbname.dbo.Tbl can only be specified when a column list is used and IDENTITY_INSERT is ON.

"


Answers (1)