方法一:

select distinct object_name(id) from syscomments where id in
(select object_id from sys.objects where type ='P') and text like'%TableName%'

方法二:

表名--》右键--》依赖关系