Member Avatar for pearl.kumar1

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..

Edited by pearl.kumar1 because: test
  • 1 Contributor
  • 2 Replies
  • 97 Views
  • 6 Minutes Discussion Span
  • Latest Post Latest Post by pearl.kumar1
Member Avatar for pearl.kumar1

I try this also..

     set identity_insert testrequisition on
    go
Edited by pearl.kumar1
Member Avatar for pearl.kumar1

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

Edited by pearl.kumar1
Be a part of the DaniWeb community

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