how to off identity insert

Mar 10 2011 2:17 AM

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)

Retrieve image