Thursday, 14 November 2013

Find any string match in store procedure.

Find any string match in store procedure.



SELECT DISTINCT OBJECT_NAME(OBJECT_ID)
     ,object_definition(OBJECT_ID)
FROM sys.Procedures
WHERE object_definition(OBJECT_ID) LIKE '%' + '<<StringTextValue>>' + '%'
Posted by at
Labels:

No comments:

Post a Comment

Thank you for your interest .

Subscribe to: Post Comments (Atom)