Query to find Table used in which Store Procedure

Posted by Kirthiga under Sql Server category on | Points: 40 | Views : 701
SELECT p.name [Procedure name]
FROM syscomments t INNER JOIN sysobjects p ON t.id=p.id
WHERE t.TEXT LIKE '%Details%'--Table Name
group by p.name order by p.name

Comments or Responses

Login to post response