--STORED PROCEDURE--

SELECT ROUTINE_NAME, ROUTINE_DEFINITION,* FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%scope_identity()%'
    AND ROUTINE_TYPE='PROCEDURE'

--OR --
SELECT OBJECT_NAME(id),* FROM syscomments
WHERE  OBJECTPROPERTY(id, 'IsTrigger') = 1 and [text] LIKE '%dbo.tblTrackingHistoryOrder%'

--OR--
declare @Search varchar
set @Search = 'Web Order'
SELECT DISTINCT o.name AS Object_Name,o.type_desc,o.type,m.definition,o.* FROM sys.sql_modules m
INNER JOIN sys.objects  o ON m.object_id=o.object_id
WHERE m.definition Like '%Web Order%' -- and o.type = 'tr' ORDER BY o.type, 2,1