Find storedProcedure by name

Question

Hello,

Is there any way I can find in SQL Server Management studio StoredProcedure by name or by part of the name ? (on active database context)

Thanks for help

Answer 1

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

if you need the code you can look in the syscomments table

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

Answer 2

Assuming you're in the Object Explorer Details (F7) showing the list of Stored Procedures, click the Filters button and enter the name (or partial name).

Answer 3

Or you can also use a red-gate product for free.

http://www.red-gate.com/products/SQL_Search/index.htm