Last modified Tables & Stored Procedures details in Microsoft SQL Server

Let's find out the last modified Tables & Stored Procedures details in MSSQL by writting a simple Query.

For User Tables

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

For Stored Procedures

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


These Queries fetching records from system object table order by last modified date & time.