The database cocould not be exclusively locked to perform the operation (SQL Server 5030 error solution)

SQL Server 5030 error Solution

When I was using SQL Server today, because I forgot to set collocation when I created the database, Chinese characters inserted in the database were garbled, so I changed collocation in the options of the database, the database cocould not be exclusively locked to perform the operation error occurs. You cannot modify the character set to chinese_prc_90_ci_as.

The solution was found for a long time, as shown below:

1. Execute SQL alter database db_database set single_user with rollback immediate

Change to single-user mode

2. Close all query windows and modify the collocation attribute of options to chinese_prc_90_ci_as.

3. Execute SQL alter database db_database set multi_user

Change to multi-user mode