Searching MSSQL database for a Stored Proc by T-SQL Definition

findSPByDefinition.sql

 sp_MSforeachdb 'SELECT "?" AS DB,
 r.SPECIFIC_SCHEMA, r.routine_name, r.ROUTINE_DEFINITION, p.ORDINAL_POSITION, p.PARAMETER_MODE, p.PARAMETER_NAME, p.DATA_TYPE
 FROM [?].INFORMATION_SCHEMA.ROUTINES r
 JOIN [?].INFORMATION_SCHEMA.PARAMETERS p  ON r.SPECIFIC_SCHEMA = p.SPECIFIC_SCHEMA AND r.SPECIFIC_NAME = p.SPECIFIC_NAME
 WHERE
   r.ROUTINE_TYPE = ''PROCEDURE''
   AND left(r.ROUTINE_NAME,2) <> ''dt''
   AND r.ROUTINE_DEFINITION LIKE ''%someSQLCode%''
 ORDER BY r.SPECIFIC_NAME ASC, p.ORDINAL_POSITION ASC'