Thanks Alex,

Yeah the idea mentioned earlier actually worked the best. That idea was to set the database into single user mode with rollback immediate. That does place it...

Well let's hope that Yukon at least has an administrative stored procedure or method to drop databases with active connections. That's one of the nice things about Oracle, is...

AER. Sorry I said Alex, but I meant you. Yes, I have tried that. It does not work. I am using SQL Server 2000 SP2. ...

Thanks for your help everyone. This helps.

Thanks for the information Alex, but you cannot take the database offline if there are users connected to it. You are not allowed to change the database state with...

Placing the database into single user mode with rollback immediate worked. Thanks!

OK, thanks everyone for the help. I'll try the alter database method listed above and see if that does it. The problem I am having is that PeopleSoft...

I don't believe it!!! Microsoft lied!

The killdatabase method does NOT drop a database regardless of connections, activity or state as it clearly states in the booksonline. If there...

Ok, we're getting closer = ). But can someone help me out with either a VB script or that sp_oa thing? I'm not an object oriented programmer so...

I second that. Yes, you can. I am doing it now in a view I created.

Yeah I am familiar with the drop database command. I am interested in getting more information on the killdatabase method mentioned in SQL Server Books online that kills a...

Thanks!

Sry forgot to add on that last note, in the SQL Server Error Log, I get this:

The backup data in 'E:\Backup\dummyname' is incorrectly formatted. Backups cannot be appended, but existing...

I believe you must first perform a backup in order to truncate the log. Then you should be able to remove it.

Yes, thank you. We are planning on using Datacenter. I'll try scanning the other threads, but if someone has information off the top of their head on how...