Noel,

Are you saying that "ALTER TABLE xx ALTER COLUMN yy COLLATE zz" does not change the data in the table, that it only changes how the table appears to the world?

So could we get away with a "SELECT a,b,c INTO temp_xx" and then a "DROP TABLE xx", rename table ?

We do not have disk space for an additional copy of the entire database, and only maybe we have space for an extra copy of our biggest table.

I know that USB drives are not that expensive, but they require site visits (which are very expensive).

TIA

Henrik Staun Poulsen