/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

0 vote353 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
2 votes354 views1 answer
Sqlite insert if not exists
SQL
0 vote349 views1 answer
Oracle shrink table
SQL
0 vote352 views1 answer
Android sqlite get rows count
SQL
13 votes327 views5 answers
Oracle list tables
SQL
0 vote358 views1 answer
Get date ISO in psql
SQL
4 votes368 views2 answers
Tsql utf to local time
SQL
0 vote374 views1 answer
How to print some string in mysql
SQL
0 vote379 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
0 vote344 views1 answer
Mysql trim characters
SQL