A personal repository of random information in compensation for a fatigued biological computer
Breaded IT » MS Access / SQL Server reminders » 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%'