Posted by Matthew Wells on 11/06/07 04:36

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@greenms.com> wrote in message
news:13ivmdkpulu8qd8@corp.supernews.com...
> "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]