SQL 7.0 :Cannot insert explicit value for identity column in table ''abc'' when IDENTITY_INSERT is set to ON

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

  • No work around just do as the message asks!

    Insert Into dbo.tablename (column list, which you did not supply)

    Values (etc...)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply