Check Recently Modified Objects in SQL Database

Run the below query, it will show objects in recently modified order.

SELECT name, create_date, modify_date
FROM sys.objects order by 3 desc

For full detail, you can use below query,

SELECT * FROM sys.objects order by modify_date desc

Ebook Download
View all
Learn
View all