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

4 votes114 views2 answers
Tsql utf to local time
SQL
1 vote88 views1 answer
Strict in postgres SQL
SQL
6 votes129 views3 answers
Create database mysql utf8
SQL
0 vote119 views1 answer
Postgresql remove duplicate rows 2 columns
SQL
0 vote163 views1 answer
SQL Server Altering Column to be Unique
SQL
1 vote126 views1 answer
Sql server: query to find out all the places where the table is used
SQL
0 vote115 views1 answer
Sql constarint
SQL
0 vote166 views1 answer
Example database query
SQL
1 vote106 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL
0 vote120 views1 answer
Comma seperated join mssql
SQL