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%'

No comments:

Post a Comment