Friday, September 28, 2012

Find Stored Procedure Related to Table in SQL Server


Following the code support for find all the Stored Procedures related to the table.

SELECT DISTINCT so.name
FROM syscomments sc
INNER JOIN sysobjects so ON sc.id=so.id
WHERE sc.TEXT LIKE '%tablename%'