Posted by teddysnips on 10/31/06 08:46

MC wrote:
> As far as I can see, you have set identity_insert on for another table. You
> first need to set it to off before inserting into tblAdminUsers.
> So (if I'm not missing something):
>
> set identity_insert BSAVA_Archive_Test_2006.dbo.GPS_CHAR OFF
>
> and then go with the
> SET IDENTITY_INSERT tblAdminUsers ON
> insert...
>
> SET IDENTITY_INSERT tblAdminUsers OFF

Thanks for at least trying to answer the question! Unfortunately, your
suggestion:

set identity_insert BSAVA_Archive_Test_2006.dbo.GPS_CHAR OFF

returns the error:

'BSAVA_Archive_Test_2006.dbo.GPS_CHAR' is not a user table. Cannot
perform SET operation.

Since the intent of the operation is to create an archive database
(which is, for this purpose, read-only) I have removed the IDENTITY
attribute from the fldUserID column.

However, I'm still interested to know why this has happened, if anyone
has any ideas!

Edward

• Next in forum: Re: Weird errors when trying to insert with IDENTITY_INSERT on!
• Prev in forum: Re: Need to declare multiple values
• Thread view: Re: Weird errors when trying to insert with IDENTITY_INSERT on!

[Reply to this message]