How To Check When Objects was Modified Last Time

Being a dba and developer, there are situations where we need to find out last modified date for object. In this post you will learn how to check when objects was modified last time

 

We can use below query to find out last modified date for object( table, function, trigger, stored procedure etc)

  

SELECT name,

       create_date,

       modify_date FROM   sys.objects

ORDER  BY modify_date DESC

 

Or we can provide the name of object for which we want to know the last modified date.