SQL Server Collation

• Tsinelas

  Say Hey Kid

  Points: 707

  More actions

  December 16, 2014 at 7:41 pm

  #397786

  Hello SQL Masters,

  Greetings!

  Is there any other way on how to change the collation of SQL Instance level?

  Cheers!

  Tsinelas

• Shafat Husain

  SSCrazy

  Points: 2754

  More actions

  December 16, 2014 at 10:04 pm

  #1765072

  Dear Tsinelas,

  Yes it is possible to change the collation on the server level, however it is a complex process and requires a lot of preparation.

  You will have a rebuild the master database using the new collation and will have to create all you user databases from scratch.

  Refer to BOL for detailed documentation:

  # http://msdn.microsoft.com/en-IN/library/ms179254.aspx

  Hope it helps..!!!

  Regards

  Shafat Husain

  Regards,
  Shafat Husain
  🙂
  And Your Lord Never Forgets...!! (64:19 -- Quran)