I need to know how to determine when a database was last accessed but haven't been able to locate instructions on doing so. I've looked at the file and the Last Modified date hasn't changed. Database properties from within SQL Server Enterprise Manager isn't helping either.
Perhaps there is a Transact SQL query I can run?
Any help is appreciated.