Fahad Zia

List Stored Procedures by Modified Date

SQL Server 2005:

SELECT * FROM sys.objects WHERE type = 'P' ORDER BY modify_date  DESC

SQL Server 2000:

SELECT * FROM sysobjects WHERE type='P' ORDER BY crdate DESC; -- refdate supposedly should be the date modified column but both return the same date

If you notice in SQL 2000, crdate and refdate show the same date so there is no way to sort by date modified with the above query

Leave a Reply