Hello,

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?

Thanks.

Matthew Wells
Matthew.Wells (AT) FirstByte (DOT) net

"Matthew Wells" <Matthew.Wells (AT) FirstByte (DOT) net> wrote

You can only enable IDENTITY_INSERT on one table at a time. Sounds like
you're trying to do it on two tables at once.




--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

I said "To test this, I tried to set it on another table and got the
message that it was already on the table I want" meaning that I confirmed
that it was set on the table I wanted.

This one is really stumping us. I've googled all night!!!



"Greg D. Moore (Strider)" <mooregr_deleteth1s (AT) greenms (DOT) com> wrote

Matthew Wells (Matthew.Wells (AT) FirstByte (DOT) net) writes:
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 (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx