declare @sql nvarchar(max)
set @sql=''
select @sql=@sql+'if exists(select '+c.name+' from '+o.name+' where '''+c.name+'''>''2013-03-01'') print '''+o.name+'***'+QUOTENAME(c.name)+'''' from syscolumns c
inner join systypes t on c.xtype= t.xtype
inner join sysobjects o on c.id= o.id
where o.xtype='u' and t.name='datetime'
order by o.name, c.name,t.name
exec(@sql)
set @sql=''
select @sql=@sql+'if exists(select '+c.name+' from '+o.name+' where '''+c.name+'''>''2013-03-01'') print '''+o.name+'***'+QUOTENAME(c.name)+'''' from syscolumns c
inner join systypes t on c.xtype= t.xtype
inner join sysobjects o on c.id= o.id
where o.xtype='u' and t.name='datetime'
order by o.name, c.name,t.name
exec(@sql)