Find Text In SQL Code

• Tweet
• 

        Simple stored procedure used to find text inside other SQL code - great for dependency checking during development.

Oskar Austegard
<a href="http://mo.notono.us">http://mo.notono.us</a>

ALTER PROC __FindText
	@query varchar(100)
AS
SELECT DISTINCT name, type 
FROM sysobjects so INNER JOIN syscomments sc ON so.id = sc.id
WHERE text LIKE '%' + @query + '%'
ORDER BY name

Tags:
• monotonous
• procedure
• server
• SQL
• stored