Discussion ForumSQL query to find Stored Procedure related to tables
1 Answers
vinod palne Staff answered 1 year ago
 

This query will help you to find Stored Procedure related to tables in SQL Server

SELECT DISTINCT t2.Name
FROM syscomments t1
INNER JOIN sysobjects t2 ON t1.id=t2.id
WHERE t1.TEXT LIKE ‘%AYourtablenamen%’