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.
"