SELECT DISTINCT 'TABLES'	 AS OBJECT, t.TABLE_TYPE AS OBJECT_TYPE, t.TABLE_NAME	AS [OBJECT_NAME]  
  FROM INFORMATION_SCHEMA.Columns c INNER JOIN INFORMATION_SCHEMA.Tables t
    ON t.TABLE_CATALOG = c.TABLE_CATALOG AND t.TABLE_SCHEMA = c.TABLE_SCHEMA AND t.TABLE_NAME = c.TABLE_NAME 
 WHERE COLUMN_NAME IN ('acct_ledger', 'acct_num')
 UNION
SELECT DISTINCT 'ROUTINES'	AS OBJECT, ROUTINE_TYPE  AS OBJECT_TYPE, ROUTINE_NAME	AS [OBJECT_NAME]  
  FROM INFORMATION_SCHEMA.Routines 
 WHERE ROUTINE_DEFINITION LIKE '%acct_ledger%'
    OR ROUTINE_DEFINITION LIKE '%acct_num%'

quote:

---

Originally posted by X002548

...like...

SELECT DISTINCT 'TABLES'	 AS OBJECT, t.TABLE_TYPE AS OBJECT_TYPE, t.TABLE_NAME	AS [OBJECT_NAME]  
  FROM INFORMATION_SCHEMA.Columns c INNER JOIN INFORMATION_SCHEMA.Tables t
    ON t.TABLE_CATALOG = c.TABLE_CATALOG AND t.TABLE_SCHEMA = c.TABLE_SCHEMA AND t.TABLE_NAME = c.TABLE_NAME 
 WHERE COLUMN_NAME IN ('acct_ledger', 'acct_num')
 UNION
SELECT DISTINCT 'ROUTINES'	AS OBJECT, ROUTINE_TYPE  AS OBJECT_TYPE, ROUTINE_NAME	AS [OBJECT_NAME]  
  FROM INFORMATION_SCHEMA.Routines 
 WHERE ROUTINE_DEFINITION LIKE '%acct_ledger%'
    OR ROUTINE_DEFINITION LIKE '%acct_num%'

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

---

SELECT OBJECT_NAME(m.object_id) AS Name,m.definition
FROM sys.sql_modules m
INNER JOIN sys.objects o
ON o.object_id = m.object_id
WHERE m.definition like '%column name here%'
AND o.type='P'