Moving from SQL collation to windows collation

• zvisuf

  SSC Veteran

  Points: 290

  More actions

  December 19, 2002 at 3:57 am

  #159043

  WHen I upgraded form sqlserver 7 to 2000 I used SQL collation in order to keep backwards compatibility.

  When I finished upgrading all the servers to 2000 I decided to move to windows collation,and since then every new server installation is done with windows collation.

  The problem is how to change the collation in the existing servers.I can change the default collation of the server and of each database easily, but changing the collation for every column seems too heavy.

  Did anybody go through this issue?

• Andy Jones, DBA

  Hall of Fame

  Points: 3641

  More actions

  December 19, 2002 at 4:18 am

  #444789

  Does the latest article offer any help?

  http://www.sqlservercentral.com/columnists/glarsen/collate_part1.asp

  (If not, this article also mentions a part 2 which may be of more help).

  Regards,

  Andy Jones

  .