in lack of better suggestions i'll prefere Allan's plan, because I excpect to loose the column collation this way (what's not in the script can not be written to the...

Hello,

this does not clear the column collation. If, after column altering, the database collation is changed it takes no effect on the altered columns.

I want to get rid of the column collations.

Thanks,...

Thanks you for your answer.

If I say 'some' columns I mean over 2000 colunms. So it's not a good idea to alter them per drop an create.

Klaus