sql server change collation
1. Stop SQL Server Services.
Open “Service”, stop all "SQL ***" service
2. Open a Command Prompt and Navigate to the Binn Directory (C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn) (Run cmd as Administor)
In cmd console, input below text and then click "Enter"
cd C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn
3. Apply a New SQL Server Collation
In cmd console, input below text and then click "Enter" again. (Tips: iThe spend time depends on the database size in your sql server, when finished, please close the cmd manually)
sqlservr -m -T4022 -T3659 -s"MSSQLSERVER" -q"SQL_Latin1_General_CP1_CI_AS"
4. Start SQL Services and verify collation