Its used for searching a keyword in all stored procedures func etc.sql

search in contents of stored procedures

SELECT DISTINCT
       o.name AS Object_Name,
       o.type_desc
  FROM sys.sql_modules m
       INNER JOIN
       sys.objects o
         ON m.object_id = o.object_id
 WHERE m.definition Like '%your keyword here%';
 
 ----------------------------------------------
 /*use sp_helptext to see definiton of the sp or func*/
 --sp_helptext spNameHere