查询表prc_location_all_view所在的存储过程
SELECT DISTINCT object_name(id) from syscomments where id IN (SELECT object_id from sys.objects where type=‘p‘) AND text like ‘%prc_location_all_view%‘
SQL大圣之路笔记——查询表所在的存储过程
原文：http://www.cnblogs.com/allenzhang/p/5103064.html
