DECLARE @Mask varchar(2000)
SELECT @Mask = 'invoice_type', @Mask = '%' + @Mask + '%'

SELECT  so.name        , so.type                                                                                                                                                                                                       
FROM dbo.syscomments sc1
INNER JOIN dbo.sysobjects so ON so.id = sc1.id
LEFT JOIN dbo.syscomments sc2 ON sc2.id = sc1.id AND sc2.number = sc1.number AND sc2.colid = sc1.colid + 1
WHERE sc1.encrypted = 0
AND (sc1.text LIKE @Mask
 OR RIGHT(sc1.text, LEN(@Mask)) + LEFT(sc2.text, LEN(@Mask)) LIKE @Mask
            )
order by so.name

select j.name,s.step_name,s.command,sch.next_run_date,sch.next_run_time
from msdb.dbo.sysjobsteps s
join msdb.dbo.sysjobs j on j.job_id = s.job_id
left join msdb.dbo.sysjobschedules sch on sch.job_id = s.job_id
where command like '%SEARCH_STRING%'

SELECT	j.job_id,
	s.srvname,
	j.name,
	js.step_id,
	js.command,
	j.enabled 
FROM	dbo.sysjobs j
JOIN	dbo.sysjobsteps js
	ON	js.job_id = j.job_id 
JOIN	master.dbo.sysservers s
	ON	s.srvid = j.originating_server_id
WHERE	js.command LIKE N'%KEYWORD_SEARCH%'

DECLARE @Mask varchar(2000)
SELECT @Mask = 'spImportTicket', @Mask = '%' + @Mask + '%'

select Object_Schema_Name([Object_id]),OBJECT_NAME([Object_id]),definition
from sys.sql_modules
where definition like @Mask