Where to find Object Created date?
In SSMS have open Object Explorer and Object Explorer details.
The details view of the latter will show created date.
Thanx to Kim Bach
You can also use a query:
USE AdventureWorks; GO SELECT name, create_date, modify_date FROM sys.objects WHERE type = 'P' AND name = 'uspUpdateEmployeeHireInfo' GO
Thanx to Pinal Dave