Forum Discussion

Gani_TpT's avatar
Gani_TpT
Copper Contributor
Sep 24, 2024
Solved

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

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 ...
  • olafhelper's avatar
    olafhelper
    Sep 25, 2024

    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.

     

olafhelper's avatar
olafhelper
Bronze Contributor
Sep 25, 2024

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.

 

Gani_TpT's avatar
Gani_TpT
Copper Contributor
Sep 27, 2024

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

Resources