Recently one of my co-workers dropped me an IM asking how he could find what stored procedures depended on a certain table. After a little digging we came up with the following query which will return a listing of stored procedures that depend on a particular table (T_TableName).
select distinct so.name from syscomments sc
inner join sysobjects so on sc.id = so.id
where xtype = 'P' AND charindex('T_TableName', text) > 0
It would be cool if within SqlBuddy, VS.NET, SQL Enterprise Manager, (name your favorite DB tool) you could right click on a table and view stored procedure dependencies!
Update: For those of you interested in the real way to do this use sp_depends, thanks Darrell!