Changing the clollation settings for MASTER DB

• santhosh411

  Ten Centuries

  Points: 1155

  More actions

  August 30, 2012 at 4:57 am

  #393052

  Please tell me how to change the database collation settings for master DB

• rfr.ferrari

  SSCertifiable

  Points: 6879

  More actions

  August 30, 2012 at 6:06 am

  #1531813

  well, this article can help you: dd207003

  but, the informations in msdb like as job's, alerts, operators will be deleted!!!

  others modifications made by users on database master and model will be deleted too.

  be careful!

  ---

  [font="Times New Roman"]rfr.ferrari[/font]
  DBA - SQL Server 2008
  MCITP | MCTS

  remember is live or suffer twice!
  the period you fastest growing is the most difficult period of your life!

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  August 30, 2012 at 6:36 am

  #1531835

  Another possible option: http://spaghettidba.com/2011/05/26/changing-server-collation/

  -- Gianluca Sartori