How to change database encoding after creation?

Question

SQL

Welcome all.
The database has already been created and it has data that needs to be saved.
I'm trying to run a query: ReturnsALTER DATABASE zk COLLATE Chinese_PRC_CI_AS

Сообщение 5030, уровень 16, состояние 5, строка 1
Базу данных нельзя заблокировать монопольно для выполнения операции.
Сообщение 5072, уровень 16, состояние 1, строка 1
Не удалось выполнить инструкцию ALTER DATABASE. Параметрам сортировки по умолчанию для базы данных "zk" невозможно установить значение Chinese_PRC_CI_AS.

As I read it's not really an encoding, but Collation is a collation table, defines how to compare strings

Answer 1

The database cannot be locked exclusively to perform an operation.

and if so? (after making sure that there are no other connections to zk updated thanks to Konstantin Tsvetkov .. although with a closed base, as far as I remember, it would have worked)) :

use master
GO
ALTER DATABASE zk COLLATE Chinese_PRC_CI_AS

ps

Collation is a collation table

what do you want? on - the - fly recoding ? _ _ _ _ _ _ _