Friday, August 27, 2004

To get a list of all the procedures created or updated recently, simply run this query in SQL Server

SELECT
ROUTINE_NAME, CREATED, LAST_ALTERED
FROM
INFORMATION_SCHEMA.ROUTINES
WHERE
ROUTINE_TYPE = 'PROCEDURE'
ORDER BY LAST_ALTERED DESC"

0 Comments:

Post a Comment

<< Home