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)
No comments:
Post a Comment