/SQL/Find string in stored procedure sql server

Find string in stored procedure sql server

SELECT name
FROM   sys.procedures
WHERE  Object_definition(object_id) LIKE '%strHell%'

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

31 votes328 views3 answers
SQL Server change column data type
SQL
1 vote328 views1 answer
Mysql current time
SQL
0 vote357 views1 answer
Sql: extract day text from datetime value
SQL
0 vote333 views1 answer
After kill process Failed to start mysqld.service: Unit mysqld.service not found.
SQL
0 vote365 views1 answer
Write SQL in ruby on rails
SQL
3 votes327 views1 answer
Pl sql escape &
SQL
1 vote330 views1 answer
Access the postgres psql
SQL
11 votes344 views1 answer
Oracle view source
SQL
0 vote327 views1 answer
Install sql server windows 10
SQL
5 votes325 views1 answer
Oracle generate list of dates in between a date range
SQL