Posted by Erland Sommarskog on 11/06/07 07:57

Matthew Wells (Matthew.Wells@FirstByte.net) writes:
>
> I have set the IDENTITY_INSERT on a table to ON. To test this, I tried
> to set it on another table and got the message that it was already on the
> table I want. But every time I try to insert records, it keeps telling me
> the IDENTITY_INSERT is off!!!
>
> Anyone know why?

Why do you use IDENTITY in the first place, if you want to insert explicit
values?

Maybe you could post a script that demonstrates your issue. Else we have to
guess what you are doing.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]