Hi to all,

I try to insert a values in SQLSERVER 2005,It shows "Msg 544, Level 16, State 1, Line 1
Cannot insert explicit value for identity column in table 'designation' when IDENTITY_INSERT is set to OFF."

BEGIN TRAN
INSERT INTO DESIGNATION (ID,DESIGNATION) VALUES(17,'TEST')
COMMIT

Kindly Suggest How to Solve this ISsue..

I try this also..

     set identity_insert testrequisition on
    go 

It Works..(it's my fault),TY.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.