Revision: 37608
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at December 14, 2010 00:13 by axs221
Initial Code
-- Search Table Field Names
select a.name, b.name
from syscolumns a
inner join sysobjects b on a.id = b.id
where LEFT(b.name,3) IN ('tbl','sys')
AND a.name LIKE '%KEYWORD%'
order by b.name
-- Search Stored Procedure Text
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
-- OR this alternative:
SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%prSendCdoSysMail%'
AND ROUTINE_TYPE='PROCEDURE'
ORDER BY ROUTINE_NAME
Initial URL
Initial Description
Search SQL Server field names and stored procedure text, based on a keyword.
Initial Title
Search SQL Server field names and stored procedure text
Initial Tags
sql, search, server
Initial Language
SQL