We had a similar issue and (because the end users are smart) I gave them DTS via enterprise manager and select only permissions. I let them know they couldn't do this during peak...

Use QA (Doesn't need access to userdb) and  sp_who to find the SPID for the relevant process.

Then use the kill command to release it.  

Sorry about that..I should have put into the post  (I thought it would be assumed) that these users have access to the Databases, but they aren't coming up on the drop...

You weren't dozing at your desk when your colleague mentioned this command to you?

Antares - Cheers..That's a handy list

Eoin

Hi AJ,

Nope, Not set to Auto-Close and my advance Coffee brewing techniques require at least 7-8 Minutes. Perhaps if I set the DB's to Auto-Close I can get it up...

You can alter tables (In a Similar Way to EM on SQL2000) using Visual Interdev if you use an DBO login

Cheers Scott. I think we'll go with views + DTS. Looks good in testing.

Is there replication running on this DB?

I have to do this between two servers on a very slow line and one of the servers (Destination) uses 6.5. (Source =2000). I'm just about to go on a...

DTS - Execute SQL Task option - Using Query builder.

Probably don't want to give that out though.

Before you can reload the master database, you must start SQL Server in single-user mode.

To start SQL Server in single-user mode

We came up with this (I think the comment could be a problem down the line that is why it is in here)

System Stored Procedures (Tasks) (Level 1)

Can you connect via ISQL (Query Analyser)?

ALTER DATABASE Userdb COLLATE  Latin1_General_CI_AS.

Will change the user db's - You can't change the tempdb because it is a system db