none
SQL SERVER RRS feed

  • Question

  • WHEN changing the collation getting the below error .what is the cause and solution

    Used the following commands to change the collation 

    C:\Program Files\Microsoft SQL Server\MSSQL13.SQLCLU1\MSSQL\Binn>dir sqx.exe

    C:\Program Files\Microsoft SQL Server\MSSQL13.SQLCLU1\MSSQL\Binn>sqlservr -m -T4022 -T3659 -s"QAPERFORMANCE\SQLCLU1" -q"SQL_Latin1_General_CP1_CI_AI"
     

    

    UNABLE TO CHANGE THE COLLATION SETTING..
    • Edited by Vanchan007 Sunday, October 28, 2018 8:38 PM
    Sunday, October 28, 2018 7:26 PM

All replies

  • The option -q is undocumented and entirely unsupported. I played with it some time ago, and under good conditions it worked, but it was not difficult to construct a case where it would fail and stop half-way.

    I hope that you have backups for your databases.

    Changing collations across all databases is unfortunately a difficult and painful exercise.


    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

    Sunday, October 28, 2018 10:25 PM