查看与某一个表相关的视图、存储过程、函数

--select * from sysdepends where depid=object_id('cse_log_header')
select a.* from sysobjects a, syscomments b where a.id = b.id and b.text like '%cse_log_header%'
select * from sys.sysobjects where xtype='P'
select * from syscomments

http://www.cnblogs.com/xx_cs/archive/2011/04/14/2016241.html