Collation matter

Dear all,
We've got one db allocated in a SQL SERVER 7.0 and another one with
compatibility with 6.5 and now we want to move it to SQL SERVER 2000.
Change collation at server/db is easy, but problem is for all the columns.
Does anyone have any script for do that automatically?
Thanks a lot for any comment,See if this post is of any help:
http://groups.google.co.uk/group/mi...l=en&lr=&rnum=2
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:0487C7B1-398D-4A9A-824A-88B5A12DA542@.microsoft.com...
Dear all,
We've got one db allocated in a SQL SERVER 7.0 and another one with
compatibility with 6.5 and now we want to move it to SQL SERVER 2000.
Change collation at server/db is easy, but problem is for all the columns.
Does anyone have any script for do that automatically?
Thanks a lot for any comment,sqlsql