select * from sys.objects where object_id in (select id from syscomments where text like '%update%tbl_TransactionalHeaders%') select TEXT from syscomments where text like '%update%tbl_TransactionalHeaders%' select -- name, C.text, substring(C.text, charindex('tbl_TransactionalHeaders', C.text) - 200, 200), substring(C.text, charindex('tbl_TransactionalHeaders', C.text) - 20, 500) from sys.objects O inner join syscomments C on O.object_id = C.id where C.text like '%update%tbl_TransactionalHeaders%' -- Example Output -- name object_id principal_id schema_id parent_object_id type type_desc create_date modify_date is_ms_shipped is_published -- usp_TransHeadersLoad 594101157 NULL 1 0 P SQL_STORED_PROCEDURE 2015-01-16 16:27:12.477 2015-03-12 17:52:38.520 0 0 -- usp_OrphanRecordCount1835153583 NULL 1 0 P SQL_STORED_PROCEDURE 2015-03-10 15:34:14.327 2015-03-10 15:34:14.327 0 0