Change the server collation in sql server 2005

• rajuu_2020

  SSC Rookie

  Points: 25

  More actions

  April 3, 2008 at 1:01 am

  #184791

  Dear sir,

  i am tring to 'rebuildm' command to chage the database collation.since this command only used for change the collation in sql server 2000. but i want to change the collation for sql server 2005.how can i done this .................?

  please reply .very urgent

  thanks.......

  regards,

  rajesh

• SQLZ

  SSChampion

  Points: 12872

  More actions

  April 3, 2008 at 1:08 am

  #797641

  Rajesh,

  It's changed in SQL 2005, you have to do it through setup. Have a look at this article:

  http://msdn2.microsoft.com/en-us/library/ms179254.aspx

  Karl
  source control for SQL Server