Hello,

I have to do some maintenance on a SQL 2000 database. I have to build a script to alter some tables in this database. I found out that collation is set on some fields in some tables. I want to reset collation of these fields to the default, but I can't get it right. I tried these variants of Alter Table:

Alter Table <tablename> Alter Column <fieldname> Collate
Alter Table <tablename> Alter Column <fieldname> Collate ''
Alter Table <tablename> Alter Column <fieldname> Collate ' '
Alter Table <tablename> Alter Column <fieldname> Collate []
Alter Table <tablename> Alter Column <fieldname> Collate [ ]

None of these statements work.
Has anyone an idea how to reset the collation?

TIA,

Martin