Post reply

Change the Collation Setting for Clustered SQL Server 2014 Instance

  • November 23, 2016 at 11:12 pm

    #401116

    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

  • November 24, 2016 at 1:23 am

    #1914377

    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

  • November 28, 2016 at 3:01 am

    #1914669

    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

  • November 28, 2016 at 8:43 am

    #1914749

    Thanks for the article, good graphics.

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

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