Posted by teddysnips on 10/31/06 09:52

Tony Rogerson wrote:
> Hi Edward,
>
> Just ignore celko, he's an arrogant idiot with little real industrial
> experience; he teaches standard sql and database design and that's it, but
> that seems to have been picked up through doing a maths degree or something;
> the old self-taught problem some people have....
>
> Anyway, MC's answer should give you what you need.
>
> Tony.

Thanks Tony - I'd sort of worked out that Celko had self-esteem issues!

However, MC's answer doesn't give me what I need - in fact, the more I
delve, the weirder it gets.

I tried re-scripting the database without the Defaults - since it's
going to be a read-only archive they're not important.

I hadn't noticed that there was something really weird about the INSERT
error:

IDENTITY_INSERT is already ON for table
'BSAVA_Archive_Test_2006.dbo.GPS_CHAR'. Cannot perform SET operation
for table 'tblAdminUsers'

It references a database called "'BSAVA_Archive_Test_2006". However
this is NOT either of the two databases that I'm operating on! In
fact, it's an old test database so I dropped it.

Now I get the following error message:

"Could not find database ID 56. Database may not be activated yet or
may be in transition."

I'm completely baffled!

Edward

[Back to original message]