My Learnings
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment