Thursday, April 21, 2016

list of stored pocs with specific table name







SELECT Name
FROM sys.procedures

WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%table name%'



------Example-------


SELECT Name
FROM sys.procedures
WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%account_total%'

No comments:

Post a Comment