If you are trying to drop a database that is in use, you will get an error message like this: 'Cannot drop database "GlobalGuidelineData" 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 GlobalGuidelineData

GO

USE GlobalGuidelineData

GO

DROP DATABASE GlobalGuideLineDatabase

GO

Msg 3702, Level 16, State 4, Server LOCALHOSTSQLEXPRESS

Cannot drop database "GlobalGuideLineDatabase" because it is

currently in use.

USE master

GO

DROP DATABASE GlobalGuideLineDatabase

GO