Yes it helps me. My server is SQL server 2000.

But I cannot change collation when the column is indexed and other fun alert of SQL server.

How do you do the changing of the old collation name of all tables ?