search stored procedures by name
snippet in sql

search stored procedures by name

user9457

select * 
from 
   sys.procedures 
where 
   name like '%name_of_proc%'