Database in Use When Dropping a Database in SQL Server
Why I am getting this error when dropping a database in SQL Server?
If you are trying to drop a database that is in use, you will get an error message like this: 'Cannot drop database "FyiCenterData" 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 FyiCenterData GO USE FyiCenterData GO DROP DATABASE FyiCenterData GO Msg 3702, Level 16, State 4, Server LOCALHOST\SQLEXPRESS Cannot drop database "FyiCenterData" because it is currently in use. USE master GO DROP DATABASE FyiCenterData GO
⇒ Getting a List of All Databases on the Server in SQL Server
⇐ "DROP DATABASE" - Deleting Databases in SQL Server
⇑ Managing Databases and Physical Files in SQL Server
2016-11-24, 1182👍, 0💬
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...