To change the collation of a SQL Server database

Change the collation of the database, SQL hint 5030 error, the error message is as follows:

The database could not being exclusively locked to perform the operation.

Workaround:

1. Set the ristrict Access for the database to Single_user.

2. Execute the following statement to change the collation

 Use Master GO ALTER DATABASE ' your DB name ' COLLATE chinese_prc_ci_as GO

3. After successful execution of the above command, set Ristrict Access to Multi_user.

To change the collation of a SQL Server database