查找所有含有表名（abc）的存储过程 执行脚本

SELECT obj.Name , sc.TEXT   
FROM syscomments sc  
INNER JOIN sysobjects obj ON sc.Id = obj.ID  
WHERE sc.TEXT LIKE '%' + 'acs_routingformrouting' + '%'  
AND TYPE = 'P'