Is it possible or is there some "undocumented" means by which I can determine the history of a database, specifically with regards to each time the database was accessed (by any user or application)?
The only thing I have to work with is the database itself. The database is given to me in a BAK format. I then "restore" the backup to my instance of SQL Server. So the only data I have is that which is included in the database itself. I do not have access
to the host server that created the BAK, which means I do not have access to any of the system databases (master, msdb, etc.) or system logs on the host server.
So having only a restored copy of the database, is there any way I can extract the history of activity out of the database, such as each time it was accessed by some user, oledb provider, odbc connector, etc? BTW, the developer of the database did not create
any user-defined tables that track database activity.
View Complete Post