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/microsoft.public.sqlserver.programming/msg/2954032e3688d638?q=bart+duncan+collate+database+jacco&hl=en&lr=&rnum=2
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,

Time Difference Calculations
Customers & Phones
Return only the Third Row
Choosing one record over another
can't return zero when no rows exist using aggregate function sum