Search

Feb 14, 2007

Find text in Stored procedure

Hi,

One interesting query I found which searches word in stored procedures and returns the name of procedure which contains that word
SELECT DISTINCT
o.name
FROM sysobjects o
INNER JOIN syscomments c ON (c.id = o.id)
WHERE
xtype = 'P' and category = 0 and c.text LIKE '%SearchWord%'
ORDER BY
o.name

No comments: