Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Way to see db last accessed or modified

Author  Topic 

estelzner
Starting Member

1 Post

Posted - 2006-03-23 : 15:31:26
Does anyone know a way to find out when a database was last accessed
or modified? sysdatabases gets only create date. The date on the .mdf, .ndf will reflect even if a person has opened the database up for browsing not real update. I looked at alot of the system tables and no definitely way did I see. sysobjects has only create date, sysusers only updates when profile gets updated, etc...

Thanks,
Eve
   

- Advertisement -