When a stored procedure (or a database object) was last modified?

Some frequent questions from users can be like below:

When this stored procedure was last modified?
When this table was last modified?
When this stored procedure was created?
When this table was last created?

While create date can be easily obtained by management studio, finding last modified date is not that obvious. Please use below script to find when a database object was created and when it was last modified including type description of the object:

USE [Database Name] ;
GO
SELECT name, create_date, modify_date,type_desc
FROM sys.objects
where
name = '[Object Name]’
GO

Comments