I Got Error Message How to resolve this

Hi,

please check identity columns in 'Customer' table. if it is autoincrement column, you should not pass value when inserting/updating 'Customer' table.

like

insert into customer(id,name)values(1,'amit');

if 'id' column is identity and autoincrement you should use below query.

insert into customer(name)values('amit');

thanks
-amit.

You are getting this error because once have the ID key set as auto-increment you don't need to bother to enter manually a value for that field.

If you enter data in your database through SQl Server Management you will get that error again and again.

SQL server will manage the insertion of that field.

hope it helps :)

this error normally occurs when insert values to auto identity columns. if u want to insert values

SET IDENTITY_INSERT tableName ON 

please refer
http://vijaymodi.wordpress.com/2007/09/28/cannot-insert-explicit-value-for-identity-column-in-table-tbltesttable-when-identity_insert-is-set-to-off/[^]

http://www.sqlteam.com/article/how-to-insert-values-into-an-identity-column-in-sql-server[^]

hope this will help...