Sign in
Get Help

Change Master Collation

Initial Situation


We have the Master DB with a specific collation and we want to change this (same as ksubscriber)

"SQL_Latin1_General_CP1_CI_AI" or  "Latin1_General_CI_AS"

In this case, I would like to change Latin1_General_CI_AS ==> SQL_Latin1_General_CP1_CI_AI




First we need to launch CMD with administrator permissions




Navigate to Windows\System32 and  execute : sc queryex type= service state= all | find /i "SQL Server"

Under  SQL instance present in DISPLAY_NAME : SQL Server you will find the name.

Next we need to navigate in the folder where the query will be executed


C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Binn


to be sure that this is the correct folder we can check if the sqlserver.exe is present with the command " dir *.exe"

we should find the sqlservr.exe


Now we are in the correct folder we must stop the sql server



and we execute the modification query :


sqlservr -m -T4022 -T3659 -s"NAME OF YOUR INSTANCE" -q"NEW COLLATION NAME"

sqlservr -m -T4022 -T3659 -s"SQLEXPRESS" -q"SQL_Latin1_General_CP1_CI_AI"



after this we restart the SQL server and the Master DB should have the new collation










Have more questions?

Contact us

Was this article helpful?
0 out of 0 found this helpful

Provide feedback for the Documentation team!

Browse this section