Search Through Each Table In Each Db

has anyone figure out how to do this?

the closes ive come is this (found on google):

declare @sql nvarchar(4000)

set @sql = ''
select @sql = @sql + 'exec ' + name + '..sp_msforeachtable @command1='' print ''''use ' + name + ' select * from ^'''' '', @replacechar=''^''' + char(13)
from master..sysdatabases where dbid > 4
exec (@sql)


i want it to actually execute whats being printed? so that way i can search through each table in each database for something im after..

either way i dont think itll help

im trying to search all databases for a certain value... a personss name