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