Home Forums SQL Server 2005 Administering Script to Change Collation of User Database RE: Script to Change Collation of User Database

  • November 18, 2009 at 10:05 pm

    #1081357

    lokhande.deepali (11/18/2009)

    --I am assuming you know the whole server require master rebuild

    Yes , I know that to rebuid require when system databases collation has to be changed.

    I want script which can change multiple user databases collation at a single execution.

    I would not do that because it is not practical but here are two threads that may help.

    http://www.sqlservercentral.com/Forums/Topic489706-146-1.aspx

    http://www.sqlservercentral.com/Forums/Topic483920-146-1.aspx

    Kind regards,
    Gift Peddie