Hi All,
THIS IS FOR SQL 7.0
I am trying a record in a table from backend which has an identity column. I have SET IDENTITY_INSERT <table name> ON, but still get below error:
"An explicit value for the identity column in the table 'abc' can only be specified when a column list is used and IDENTITY_INSERT is ON. "
I have run DBCC CHECKTABLE, CHECKINDENT, recreated the table and loaded data and removed and added the Identity property back.
Nothing seems to be working, pleae note this is in SQL 7.0. I do know that for SQL 2000 there is a fix for the same error on Microsoft site.
Did anyone get this error and if so how did u work around for solution. Any help would be appreciated.
Thanks - Babu.