Posted by Greg D. Moore \(Strider\) on 11/06/07 03:06

"Matthew Wells" <Matthew.Wells@FirstByte.net> wrote in message
news:BKudndSpqbutUbLanZ2dnUVZ_tijnZ2d@comcast.com...
> 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!!!
>

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.


> Anyone know why?
>
> Thanks.
>
> Matthew Wells
> Matthew.Wells@FirstByte.net
>
>



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

[Back to original message]