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
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%'
you can can also use the ansi standard version
SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_NAME LIKE '%name_of_proc%'