This will list stored procedures, views, etc. that uses a given 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('tblcategorypage') AND sc.name = 'categorytype'
Credits for this tip to SQLServerCentral.
/Emil