>Hi everybody,
>
>With this select
>select Table_Name, Column_Name, Data_Type, Character_Maximum_Length from information_schema.columns where Character_Maximum_Length >=100 order by 1,2
>
>I can get a list of all potentially dangerous fields. Now I want to write a procedure to generate a script to change all of these fields to varchar(100) (not execute it, of course).
>
>How should I proceed in writting such code?
>
>Thanks in advance.

DECLARE @Test varchar(max)
SET @Test = NULL
select @Test = ISNULL(@Test,'')+'ALTER TABLE '+Table_Name+' ALTER COLUMN '+Column_Name+' '+Data_Type+'(100)'+CHAR(13)+CHAR(10) 
       from information_schema.columns where Character_Maximum_Length >=100 order by Table_Name,Column_Name
print @Test

NOT TESTED