Follow

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 SQL_Latin1_General_CP1_CI_AI ==> Latin1_General_CI_AS

2015-11-25_1141.png

 

 

First we need to launch CMD with administrator permissions

 

2015-11-25_1449.png

 

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

2015-11-25_1400.png

 

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"


2015-11-25_1425.png

 

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

 

 2015-11-25_1441.png

 

 

 

 

 

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Article is closed for comments.