Download Android App in your Android Device from Google Play Store
- Search for "Withoutbook Practice Exam Test" in Mobile/Tablet Play Store
Practice InterviewNew Search by Name or Email

Exams Attended

Make Homepage

Bookmark this page

Subscribe Email Address

MSSQL Interview Questions and Answers

Ques. Why I am getting this error when dropping a database in MS SQL Server?
Ans. If you are trying to drop a database that is in use, you will get an error message like this: 'Cannot drop database "withoutbook" because it is currently in use.'

Before dropping a database, you must stop all client sessions using this database. If your own client session is using this database, you should set a different database as the current database as shown in this tutorial example:

CREATE DATABASE withoutbook
GO

USE withoutbook
GO

DROP DATABASE withoutbook
GO
Msg 3702, Level 16, State 4, Server LOCALHOSTSQLEXPRESS
Cannot drop database "withoutbook" because it is
currently in use.

USE master
GO

DROP DATABASE withoutbook
GO
Is it helpful? Yes No

Most helpful rated by users:

©2020 WithoutBook