Change the Collation Setting for Clustered SQL Server 2014 Instance

  • Comments posted to this topic are about the item Change the Collation Setting for Clustered SQL Server 2014 Instance

    Regards,Ganapathi varma, MCSAEmail: gana20m@gmail.com

  • Good article.

    You have to consider that if you created your tempdb with multiple files and especially on another disk then you’ll have to re-check the tempdb because it will be recreated in the default DATA folder created by the SQL server installation.

    If you set up a password for the sa login then you have to re-set it. If you did some configuration (sys.sp_configure) changes, then you have to re-do them. Any changes previously done in in the master, msdb and model databases must be re-done.

    Igor Micev,
    My blog: www.igormicev.com

  • As said above by Igor, many other things need to be re-done once you have rebuild the system databases.

    You should highlight those things for any one out there who is following the article to change the collation.


    Sujeet Singh

  • Thanks for the article, good graphics.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply