Return to Snippet

Revision: 18228
at September 23, 2009 17:51 by marcocs


Initial Code
SELECT sys.sysobjects.name, sys.syscomments.text
FROM sys.sysobjects INNER JOIN syscomments 
ON sys.sysobjects.id = sys.syscomments.id
WHERE sys.syscomments.text LIKE '%KEYWORD%' 
AND sys.sysobjects.type = 'P'
ORDER BY sys.sysobjects.NAME

Initial URL
http://www.mssqltips.com/tip.asp?tip=1419

Initial Description
Find Keywords in SQL Server Stored Procs and Functions
Written By: Tim Ford

Initial Title
Find Keywords in SQL Server Stored Procs and Functions

Initial Tags

                                

Initial Language
SQL