SQL Server 2000: Text Search in Database objects

SQL Server 2000:

sysobjects.id = syscomments.id

sysobjects.name = database object name, ie proc name

syscomments.TEXT = procedure itself

SELECT DISTINCT so.name
FROM sysobjects so
JOIN syscomments sc ON sc.id=so.id
WHERE sc.TEXT LIKE '%ReconcileBenchMarkRecords%'
GO

 

 

SELECT TABLE_SCHEMA + '.' + TABLE_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME LIKE  '%app%'

SELECT TABLE_SCHEMA + '.' + TABLE_NAME

FROM INFORMATION_SCHEMA.COLUMNS

WHERE COLUMN_NAME LIKE '%app%'