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.
"
how to off identity insert
i tried to off identity insert by given syntax for copy the values
Guest UserPosted Mar 10, 2011, 10:30 AM
Please see my answer to your other posting on this topic:
http://www.c-sharpcorner.com/Forums/Thread/111933/select-query-without-identy-column.aspx