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.

     

Gani_TpT's avatar
Gani_TpT
Copper Contributor
Sep 25, 2024
Can anyone give query about this post..?

Resources