Home Forums SQL Server 2005 Administering Which Stored Procedure changed RE: Which Stored Procedure changed
John Mitchell-245523
SSC Guru
Points: 148809
More actions
March 14, 2008 at 8:28 am
#789656
Yes, something like this:
SELECT SPECIFIC_SCHEMA + '.' + SPECIFIC_NAME AS ProcName, LAST_ALTERED
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE = 'PROCEDURE'
AND LAST_ALTERED > GETDATE() - 7
John