The database could not be exclusively locked to perform the operation

SQL Server 5030 error solution

Today, when using SQL server, because you forgot to set the collation when creating the database, it is messy to insert Chinese characters into the database. So when you modify the collation in the options of database, the database could not be exclusively locked to perform the operation. You cannot modify the character set to Chinese_ PRC_ 90_ CI_ AS。

It took a long time to find a solution, as follows:

1. Execute SQL alter database db_ database SET SINGLE_ USER WITH ROLLBACK IMMEDIATE

Change to single user mode

2. Then close all the query windows and change the coordination property of options to Chinese_ PRC_ 90_ CI_ AS

3. Execute SQL alter database db_ database SET MULTI_ USER

Then change to multi-user mode