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

Similar Posts:

• [Solved] SQL Server Error: Cannot drop database XXX because it is currently in use
• [Solved] Backup mysql8.0 with the mysqldump of mysql5.7 Error
• How to Solve ra-28000 account being locked Error
• NodeJS Connect MYSQL Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
• How to Solve Client does not support authentication protocol requested by server; Consider upgrading MySQL
• [Solved] ER_NOT_SUPPORTED_AUTH_Mode node connection database error
• Trouble Connecting to sql server Login failed. “The login is from an untrusted domain and cannot be used with Windows authentication”
• [Solved] Node Connect MYSQL Error: Client does not support authentication protocol requested by server; consider upgrading MySQL client
• Oracle Error: ORA-01843: not a valid month [Solved]
• [Solved] Archlinux Upgrade Error: failed to update core (unable to lock database)