USE [SOMEdbNAME]
GO
SELECT so.name, so.modify_date
FROM SYS.OBJECTS SO
WHERE SO.name in
(SELECT ROUTINE_NAME
FROM INFORMATION_SCHEMA.ROUTINES isr
WHERE isr.ROUTINE_CATALOG='SOMEdbNAME')
ORDER BY so.modify_date desc
--complements to Igor Malkiman of Qwest Communications for this code
No comments:
Post a Comment