/ Published in: SQL
Find Keywords in SQL Server Stored Procs and Functions
Written By: Tim Ford
Written By: Tim Ford
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
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
URL: http://www.mssqltips.com/tip.asp?tip=1419