Posted by teddysnips on 10/31/06 11:38

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: Weird errors when trying to insert with IDENTITY_INSERT on!
• Prev in forum: Encryption keys for Reports Server
• Thread view: Re: Weird errors when trying to insert with IDENTITY_INSERT on!

[Reply to this message]