SQL 2008 R2 Upgrade and collation

• mssqlsrv

  SSCrazy

  Points: 2375

  More actions

  December 12, 2013 at 5:04 am

  #283409

  Hi Team,

  I need to perform SQL 2008 R2 standard edition upgrade to Enterprise.

  I can do this by running upgrade wizard.

  My question here is, Is it possible to change the collation of server as well while up-gradation of server.

• Robert Klimes

  SSCoach

  Points: 17865

  More actions

  December 12, 2013 at 7:39 am

  #1672957

  I dont think you will be able to change the server collation during upgrade. To change the server collation you need to rebuild master.

  http://technet.microsoft.com/en-us/library/ms179254(v=sql.105).aspx

  Bob
  -----------------------------------------------------------------------------
  How to post to get the best help[/url]