Google Wave from GoLocalise on Vimeo.

Find all views, stored procedures etc that use a table column


SELECT OBJECT_NAME(sd.id) Dependent_Object,
(SELECT xtype FROM sysobjects so WHERE so.id = sd.id) Object_Type
FROM sysobjects so
INNER JOIN syscolumns sc ON so.id = sc.id
INNER JOIN sysdepends sd ON so.id = sd.depid AND sc.colid = sd.depnumber
WHERE so.id = OBJECT_ID('TABLE_NAME')
AND sc.name = 'TABLE_COLUMN'