sql management studio find all procedure code example
Example: search stored procedures by name
select *
from
sys.procedures
where
name like '%name_of_proc%'
select *
from
sys.procedures
where
name like '%name_of_proc%'