Created in last 15 Days
SELECT ROUTINE_NAMEAS 'Stored Procedure'
,ROUTINE_DEFINITION AS 'Stored Procedure Text
FROM INFORMATION_SCHEMA.ROUTINES
WHERE
CREATED >= GETDATE()-15
AND
ROUTINE_TYPE='PROCEDURE'
ORDER BY ROUTINE_NAMEASC
Modified in last 15 Days
SELECT ROUTINE_NAMEAS 'Stored Procedure'
,ROUTINE_DEFINITION AS 'Stored Procedure Text
FROM INFORMATION_SCHEMA.ROUTINES
WHERE
LAST_ALTERED >= GETDATE()-30
AND
ROUTINE_TYPE='PROCEDURE'
ORDER BY ROUTINE_NAMEASC
That’s It.
Enjoy Learning.
December 31, 2011
List all stored procedures modified or created in last N days
Subscribe to:
Post Comments (Atom)
The Tech Pursuit
Keep asking better questions.
© Shatrughna Kumar. The Tech Pursuit.
Views expressed here are personal and do not represent any employer.
No comments:
Post a Comment