/查询所有存储过程使用这张表名的过程
select name
from sysobjects o, syscomments s
where o.id = s.id
and text like '%表名%'
and o.xtype = 'P'
from sysobjects o, syscomments s
where o.id = s.id
and text like '%表名%'
and o.xtype = 'P'
转载于:https://www.cnblogs.com/yjm8023/p/11194598.html