How do we get DB Creation Date along with Tables/Views/SPs last access history details

[Gani_TpT]

I need below details when i connect to my SQL Server.

DB Creation Date

Tables/Views/SPs Creation Date

Tables/Views/SPs Last used/accessed  ==> Need history of one/two years when they accessed

connecting to applications host

I want all above details in one SQL Query. 

Is that possible to get all the above details in one single query..?

[#2]

Can anyone give query about this post..?

[#3 · Accepted solution]

@Gani_TpT 

DB Creation

select create_date, *
from sys.databases

Object creation

select create_date, *
from sys.objects

SQL Server don't log a "access history", so not possible to get the informations.

[#4]

Hi @olafhelper ,

Thanks for your reply.

can we get details of DML commands, particularly when was the last SELECT statement executed either from applications or run from sql query window..?