查询所有存储过程使用这张表名的过程
方法一:
select name
from sysobjects o, syscomments s
where o.id = s.id
and text like '%表名%'
and o.xtype = 'P'
方法二:
select * from sys.all_sql_modules where definition like '%UDT_MES_GraphiteStoveRecord%'
方法一:
select name
from sysobjects o, syscomments s
where o.id = s.id
and text like '%表名%'
and o.xtype = 'P'
方法二:
select * from sys.all_sql_modules where definition like '%UDT_MES_GraphiteStoveRecord%'