Error in Identity Column - IDENTITY_INSERT is ON

You also need to specify a column list for your insert statement as in:

INSERT INTO my_table (column1, column2, ...)

Darsipudi, please use proper TITLE and proper forum category when posting your question. I have changed your title and it makes more sense now.

Thanks!

You're attempting to insert a value into a column that is defined with the IDENTITY property.  The values in Identity columns are automatically generated by the database, so you can't insert your own values in those columns unless you use the SET IDENTITY_INSERT command as described here:

http://msdn.microsoft.com/en-us/library/ms188059.aspx