SET IDENTITY_INSERT CI_Equipment ON ? sql server 2008
Posted on 2011-02-22
i am trying to execute the command
SET IDENTITY_INSERT CI_Equipment ON
On a table named CI_Equipment, it works well...Command(s) completed successfully.
The problem is when i try to insert a new row
INSERT INTO [CI_TevaAbic].[dbo].[CI_Equipment]
it still shows me
Cannot insert explicit value for identity column in table 'CI_Equipment' when IDENTITY_INSERT is set to OFF.
What can I do?