none
database collation

    Question

  • We would like change the Case insensitive to Case sensitive collation 

    1. How do we move from Case insensitive to Case sensitive collation 

    2. what is the impact after moved from Case insensitive to Case sensitive collation 

    Regards,

    SQL

    Wednesday, November 30, 2016 6:30 PM

All replies

  • Changing the collation for a specific database is easy enough: https://msdn.microsoft.com/en-us/library/ms175835.aspx

    But for an idea of the process, and the impact for making such a change, you should read this: http://sqlmag.com/database-performance-tuning/seven-step-process-changing-database-collation

    HTH

    Wednesday, November 30, 2016 7:13 PM