Search Text in database

 

USE master

Declare @strFind varchar(max)

Set @strFind = '%ma_cancadeal%'

select distinct object_name(OBJECT_ID) 

from sys.sql_modules 

where definition like @strFind 

order by object_name(OBJECT_ID) 

declare @sql varchar(max)

SELECT @sql = 'USE ? print ''?''; select ''?'' as DB_Name, object_Name(object_id),* from sys.sql_modules WHERE definition LIKE ''%'+@strFind+'%''' 

EXEC sp_MSforeachdb @sql