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..?

​I need below details when i connect to my SQL Server. DB Creation DateTables/Views/SPs Creation DateTables/Views/SPs Last used/accessed  ==> Need history of one/two years when they accessedconnecting 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..?   Read More

​