Showing posts with label Object used in procedures. Show all posts
Showing posts with label Object used in procedures. Show all posts

Sunday, February 26, 2012

How find Sql objects used in procedures


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