> "An explicit value for the identity column in table '%.*ls' can only be specified when a column list is used and IDENTITY_INSERT is ON".
Ashish,
Take a look at the command
SET IDENTITY_INSERT
. It will allow you to specify the value for the identity column.
Hope this helps!
Sylvain Demers