December 31, 2011

List all stored procedures modified or created in last N days

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.

No comments:

Post a Comment