USE YOURDATABASENAME

declare @Foo table (tablename sysname,colname sysname)

insert into @Foo
SELECT
 	OBJ.NAME as tablename
	,COL.NAME AS colname	
FROM 
	SYSOBJECTS OBJ 
INNER JOIN 
	SYSCOLUMNS COL  
ON 
	OBJ.ID = COL.ID
INNER JOIN 
	SYSTYPES TYP 
ON 
	COL.XTYPE = TYP.XTYPE
WHERE 
	
	TYP.NAME <> 'sysname' 
AND
	OBJ.XTYPE = 'U'


declare @SQL varchar(1000)
declare @bar int
declare @tb sysname
declare @col sysname
select @Bar = count(*) from @Foo
while @Bar > 0

begin
select @tb = tablename from @Foo
select @col = colname from @Foo
SET @SQL = ''
SET @SQL = 'UPDATE ' + @tb + ' SET ' + @col + ' = LTRIM(RTRIM([' 
+ @col + '])) WHERE ' + @col + ' <> LTRIM(RTRIM([' + @col + ']))' 

select @SQL

SET @bar = @Bar-1
end