שינוי מאפייני שפה של שרת MSSQL

Change collation of MSSQL

>> sc queryex type= service state= all | find /i "SQL Server"

DISPLAY_NAME: SQL Server (MSSQLSERVER)

DISPLAY_NAME: SQL Server Browser

DISPLAY_NAME: SQL Server Agent (MSSQLSERVER)

DISPLAY_NAME: SQL Server VSS Writer

>> net stop "SQL Server (MSSQLSERVER)"

The SQL Server (MSSQLSERVER) service is stopping....

The SQL Server (MSSQLSERVER) service was stopped successfully.

cd c:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\

-- SET CASE SENSITIVE --

sqlservr -m -T4022 -T3659 -s"MSSQLSERVER" -q"SQL_Latin1_General_CP1_CS_AS"

[-m] single user admin mode

[-T] trace flag turned on at startup

[-s] sql server instance name

[-q] new collation to be applied

-- SET CASE IN-SENSITIVE --

sqlservr -m -T4022 -T3659 -s"MSSQLSERVER" -q"SQL_Latin1_General_CP1_CI_AS"

>> net start "SQL Server (MSSQLSERVER)"