select * from syscolumns where collation = 'SQL_Latin1_General_CP850_CI_AI' and name = 'name' and id > 100 select 'alter table ' + TABLE_SCHEMA + '.' + TABLE_NAME + ' alter column ' + COLUMN_NAME + ' ' + DATA_TYPE + '(' + cast(CHARACTER_MAXIMUM_LENGTH as varchar(10)) + ') COLLATE SQL_Latin1_General_CP1_CI_AI' from information_schema.columns where COLLATION_NAME = 'SQL_Latin1_General_CP850_CI_AI' ALTER DATABASE quotes COLLATE SQL_Latin1_General_CP1_CI_AI