May 30, 2012

find Table used in number of Stored procedures

SELECT
 DISTINCT so.name
             FROM syscomments sc 
INNER JOIN sysobjects so
 on sc.id=so.id WHERE 
sc.text LIKE '%TableName%'

No comments:

Post a Comment