SQL 2008 R2 Upgrade and collation

  • 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.

  • 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]

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

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