SQL大圣之路笔记——查询表所在的存储过程

查询表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%'