Search all user stored procedures for a specific pattern

by Miro 7. August 2008 03:13

The following script returns the contents of the stored procedures which contain the specific pattern:

SELECT OBJECT_NAME(id), [text]
FROM syscomments
WHERE [text] LIKE '%my pattern%'
AND OBJECTPROPERTY(id, 'IsProcedure') = 1

Tags:

List all stored procedures using a specific search criteriaGood for creating the update scripts select '/************' + OBJECT_NAME(id) + '***...Test SQL query/stored procedure from the command line... ...using the sqlcmd utility sqlcmd -S . -d MyDatabaseName -U userName -P pazz...SQL SnippetsCalculate length of the text field use DATALENGTH(fieldName) CTE (Common Table Expression) ...

Related posts