SSMS: SQL Server Errors
Below shows the common errors happened when using SQL Server:
Unable to delete a database
Check the
Cannot drop database because it is currently in use
. In SSMS, right click on the database to be deleted:
Properties
⇒
Options
⇒
Restrict Access
: Setting to
Single User
Perform the drop afterwards by right clicking on the database.