Thursday, March 6, 2014

Find some text in stored procedure

SELECT OBJECT_NAME(object_id), OBJECT_DEFINITION(object_id)
FROM sys.procedures
WHERE OBJECT_DEFINITION(object_id) LIKE '%upperquart%'
ORDER by OBJECT_NAME(object_id)

No comments:

Post a Comment