Post reply

IDENTITY_INSERT problem

  • April 4, 2002 at 12:06 pm

    #78291

    When we transfer data between databases, we got the following error: "An explicit value for the identity column in table 'db1..seq_tablename' can only be specified when a column list is used and IDENTITY_INSERT is ON." What does this error mean? And how to resolve it?

  • April 4, 2002 at 7:46 pm

    #426671

    Explicitly trying to set the value of an Identity column is not allowed unless you use SET IDENTITY_INSERT ON or turn OFF the identity setting for the column then ON after. See SQL Books Online for details.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

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

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