Tuesday, March 27, 2012

find the table in different Store procedure

how we know, selected table is used in how much store procedure.

 SELECT DISTINCT OBJECT_NAME(id) FROM syscomments WHERE [text] LIKE '%aaaa%'

No comments:

Post a Comment