April 4, 2002 at 12:06 pm
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
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy