To get the Store procedures and tables created time

select I.*,ST.create_date from information_schema.tables as I

inner join sys.tables as ST

on I.table_name=ST.name

where I.table_schema='staging'

--and ST.Create_date between '2013-12-03' and '2013-12-02'

order by ST.create_date desc

select * from sys.objects

where type='p'

order by create_date desc