Find stored procedure by name

Question

Is there a way to search for a stored procedure in SQL Server Management Studio by name or by a part of the name? (On context of an active database)

Answer 1

Use:

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

Look at the syscomments table if you require the code.

select text 
from 
    syscomments c
    inner join sys.procedures p on p.object_id = c.object_id
where 
    p.name like '%name_of_proc%'

I hope this helps you.