Hi,
           I dont know how to retrieve the database last accessed date. 
We 
have around 25 databases in Sqlserver. Each DB got around 50 tables. I 
want to list down
1. The date last accessed of a the DBs in SQL Server.
2. The data last accessed of the tables within a DB.

Please advise.

Thanks & regards,
Priya.
Project Lead.
"Pushing the Limits"

SQL Server is C2 compliant, which means that everything can be audited.

Look in Books Online under "auditing"

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Priyadarshini" <priyadarshne@y...>
Subject: [asp_web_howto] Retrieve Date LastAccessed of Sql Server DB &Tables


: Hi,
:            I dont know how to retrieve the database last accessed date.
: We
: have around 25 databases in Sqlserver. Each DB got around 50 tables. I
: want to list down
: 1. The date last accessed of a the DBs in SQL Server.
: 2. The data last accessed of the tables within a DB.
:
: Please advise.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~