Friday, 9 October 2020

Apply a new sql server collation

 Sometimes we will get a requirement to change server collation post installations.

In such cases please follow these steps.

Execute the command below, a lot of information will appears and no user action is required, just close the prompt window after the execution ends. The parameter "-s" is only necessary if more than one sql instance exists on the target machine.


Sql server -m -T4022 -T3659 -s"SQLEXP2014" -Q"SQL_Latin1_General_CP1_CI_AI"

No comments:

Post a Comment