--use EuroGestXXXX_Docs 

--alterar collation para ser igual à da base de dados eurogestXXXX
--1º passo
--Alter Database EuroGest8002_Docs Collate Latin1_General_CI_AS



Select 'Alter Table ' + object_name(syscolumns.id) + ' alter column ' + syscolumns.name + ' ' 

+ 
(case ltrim(rtrim(lower(systypes.name))) 
when   'text' then  '  ' + systypes.name
else systypes.name + ' (' + convert(varchar(10), syscolumns.length) + ')'
End) 
+

(case syscolumns.isnullable
When 0 then ' not null'
else ' null'
end)

+ Char(13) + Char(10) + 'GO' + Char(13) + Char(10)

as Script

from syscolumns 
inner join sysobjects on sysobjects.id = syscolumns.id
inner join systypes on systypes.xtype = syscolumns.xtype
Where 
sysobjects.type = 'U'
and (systypes.name like '%text' or systypes.name like '%char%')
order by sysobjects.name, syscolumns.colorder