Post reply

Collation Change

  • May 29, 2009 at 8:37 am

    #205565

    I have recently changed collation on one of the instance which was not matching with other instances but the thing is i changed on all user databases(tables,columns) but still the sys database is with old collation. is there any easy way to change for sys databases with a short downtime and without any risk factors?

  • May 29, 2009 at 8:56 am

    #1002098

    Collation change of the Master require rebuild of the Master so if there is no reason you can just leave things as is because if you need to develop multilingual application you need to use different collations.

    http://support.microsoft.com/kb/325335

    Kind regards,
    Gift Peddie

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

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