Find stored procedure by name
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_idwhere 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%'
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).
This will work for tables and views (among other things) as well, not just sprocs:
SELECT '[' + s.name + '].[' + o.Name + ']', o.type_descFROM sys.objects o JOIN sys.schemas s ON s.schema_id = o.schema_idWHERE o.name = 'CreateAllTheThings' -- if you are certain of the exact name OR o.name LIKE '%CreateAllThe%' -- if you are not so certain
It also gives you the schema name which will be useful in any non-trivial database (e.g. one where you need a query to find a stored procedure by name).