Search stored procedures by name

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

Source: stackoverflow.com

Search stored procedures

SELECT DISTINCT
       o.name AS Object_Name,
       o.type_desc
  FROM sys.sql_modules m
       INNER JOIN
       sys.objects o
         ON m.object_id = o.object_id
 WHERE m.definition Like '%[ABD]%';

Similar codes

1 vote285 views1 answer
Primary key reset in SQL database
SQL
12 votes337 views6 answers
Distinct in sql server
SQL
3 votes291 views1 answer
Sql datetime as date
SQL
11 votes319 views1 answer
Oracle view source
SQL
2 votes297 views1 answer
Oracle index size calculation
SQL
3 votes328 views2 answers
@sqlresultsetmapping
SQL
5 votes353 views1 answer
Mysql count lines
SQL
-1 vote287 views1 answer
How to use update trigger in sql
SQL
1 vote313 views1 answer
Table infromation in sql server
SQL
0 vote295 views1 answer
Select from another database
SQL