Display TOP 'N' Last Modified Stored Procedure using SQL Server 2005/2008

In order to display a list of the TOP 5 Stored Procedure that were last modified, use this query

SELECT TOP 5 name, modify_date

FROM sys.procedures

ORDER BY modify_date DESC

On running this query on the Northwind database, the following results were obtained