Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
ERROR MESAGGE:
The database could not be exclusively locked to perform the operation.
EXPLANATION:
When performing an operation in a database (such as changing the database name or changing the Collation setting …), you may experience such an error.
SOLUTION:
There should not be another user connected to the database to perform such operations. You can also do this with a command block as follows. Note that this will kill other sessions in the database.
Change your database name:
1 2 3 4 5 6 | ALTER DATABASE MyDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE GO USE MyDB GO sp_renamedb N'MyDB', N'MyDB_Old' GO ALTER DATABASE MyDB_Old SET MULTI_USER GO |
