There is not really a quick way of doing it. To chance the collation of a
column with ALTER TABLE you have to drop and recreate all the indices,
constraints (including Primary keys and Foreign Keys), defaults and
explicitly created statistics on that column. Not a party, and I don't
think anyone has written a script to do all that yet.
Jacco Schalkwijk MCDBA, MCSD, MCSE
"Jas" <com> wrote in message