You are here: Re: IDENTITY_INSERT problem... « MsSQL Server « IT news, forums, messages
Re: IDENTITY_INSERT problem...

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
>
>

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация