Find stored procedure by name

Question

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

Thanks for help

Answer 1

You can use:

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%' 

Edit Update:

you can can also use the ansi standard version

SELECT *  FROM      INFORMATION_SCHEMA.ROUTINES  WHERE      ROUTINE_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).