I have a SQL 2000 server and a database that I want to drop.
A drop command returns "Cannot drop the database 'MyDB' becuase it is currently in use.
I tracked down the process stopping the drop and tried to Kill it, but this had no effect. I am fairly sure this is a transaction that got left open when an application crashed out as it is quite old and the PC involved has been re-booted several times since then.
So I tried 'ALTER DATABASE MyDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE' to try and force the issue, but this command runs but never completes.
How can I clear this open transaction and/or drop the database without having to re-boot the server?