How to force a drop of MSSQL Server database
- by ng01
I am trying to delete an MSSQL Server database, however I am having no luck. I have tried multiple things such as
user
ALTER DATABASE my_database
SET RESTRICTED_USER
WITH ROLLBACK IMMEDIATE;
GO
DROP DATABASE my_database;
GO
I have also tried to right click on it a delete it.
This does not work, it tells me "Cannot drop database "ima_debts" because it is currently in use". The thing is there is definately no other user connected to it. In fact I disabled TCP/IP for the database and restarted it.
Not even "Microsoft SQL Server Management Studio (Administrator)" is connected to it. I have made sure to login to "master".
Why is it telling me it is currently in use. Is it possible for me to delete perhaps a directory or something from the file system to get rid of this database?
Any help would be appreciated.
Thanks.