I need to delete my current database which I am using it , I googled around and found this answer:
http://sqlserver2000.databases.aspfaq.com/how-do-i-drop-a-sql-server-database.html
ALTER DATABASE myDataBase
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE
DELETE DATABASE myDataBase
http://sqlserver2000.databases.aspfaq.com/how-do-i-drop-a-sql-server-database.html
ALTER DATABASE myDataBase
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE
DELETE DATABASE myDataBase
No comments:
Post a Comment