How to know last updated Tables / Stored Procedures in Microsoft SQL Server 2008

Very simple query will return the result. How to know the last updated Tables / Stored Procedures in Microsoft SQL Server 2008.

Here is the query given below.

 

For Stored Procedures 

 

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

And for Tables 

 

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



Hope this will help !!!!!

Thanks
Solomon S.
(http://www.solomonsarkar.com)