Something like the following?

--===== If the test table already exists, drop it

IF OBJECT_ID('TempDB..#Diagnosis','U') IS NOT NULL

DROP...

varchar(400), nvarchar(400) depending on if it is unicode or non-unicode data.

select * from sys.master_files

growth = increment

is_percent_growth = 1 = growth(%)

is_percent_growth = 0 = groeth(MB)

That will cause it to happen.

Auto close will switch the database to offline after the last person disconnects, then when you need access it sets online which forces recovery.

I would...

What are the settings of the database(s) in question?

Auto close on?

Re-run the installer, that was a common error I had with a dodgy media disk, its another one of the object reference not set to an instance of an object...

Service stop start? Each time SQL starts up it needs to recover the database to ensure it is transactionally correct.

Google may be your friend on the 2000 side of things, as I say I dont have SQL 2000 any more so cant advise on that.

2005 you can connect to the SSAS server is SSMS and it will show you the version number as it does if you connect to the engine.

Unsure on 2000, would...

You would need to loop through dropping all the FK's, then truncate, then load then recreate the FK's

Just setting the constraint to NOCHECK still wont allow you to truncate the...

I recommend reading the MSDN article on sys.servers

http://msdn.microsoft.com/en-us/library/ms178530.aspx

What is the full output from DBCC CHECKDB .... ALL_ERRORMSGS, NO_INFOMSGS

That would indicate that all your indexes have a name. The NULL values are for tables which do not have a clustered index and are heaps.

Full backup with copy only can be used for a PIT recovery.

A copy only full backup, cannot serve as a base for differential restores.

Restore a Full backup with copy only...

Null in the name means its a heap, as a heap doesnt have an index name, it shows as NULL

Do you get anything from the below query

SELECT * FROM sys.indexes...