Posted by Tony Rogerson on 10/31/06 11:43

go for it - tonyrogerson@sqlserverfaq.com


--
Tony Rogerson
SQL Server MVP
http://sqlblogcasts.com/blogs/tonyrogerson - technical commentary from a SQL
Server Consultant
http://sqlserverfaq.com - free video tutorials


<teddysnips@hotmail.com> wrote in message
news:1162294685.248612.194640@m7g2000cwm.googlegroups.com...
>
> Tony Rogerson wrote:
>> Could it be that you are prefixing the wrong database on the SET IDENTITY
>> INSERT ?
>>
>> SET IDENTITY_INSERT [ database_name . [ schema_name ] . ] table { ON |
>> OFF }
>>
>> Can you post the complete script you are trying to run.
>>
>> Also, the output from PRINT @@VERSION
>
> I can't post the whole script as it's more than 5,000 lines, though if
> you're amenable I could email it to you and you could post your
> findings back here?!?
>
> The output from PRINT @@VERSION is:
>
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
>
> Edward
>

• Next in forum: Re: Importing text files - DTS help needed
• Prev in forum: Re: Weird errors when trying to insert with IDENTITY_INSERT on!
• Thread view: Re: Weird errors when trying to insert with IDENTITY_INSERT on!

[Reply to this message]