T-SQL query to get the created date of database Objects
How many times we come across the situation where we need to check when a particular database object was created. Say you want to get to know when a Table was created, A stored procedure was created and so on.
Microsoft has provided us with a very simple method to achieve this. You can simply run the below query to get the created date of a particular database object. Just Replace ObjectTobeSearched with the name you want to search
select crdate as [Object_Created_Date] from dbo.sysobjects where [name] = 'ObjectTobeSearched'