When did a user last access Database?

[arst06d]

Hi

I have a couple of databases on SQL2000 which I don't think anybody accesses.

I know you can see current database acivity in EM, but will there be a log somewhere of which users accessed the database and when? Is there some sort of logging which I can switch on for this?

The access will be by way of linked tables in an Access database.

I know I could just rescind permissions and wait for people to squeal, but I think that would be frowned upon!

Thanks

David

 

[arst06d]

I'm assuming I cannot find anything historical, so I've started a trace on these databases.

 

[maswien]

You can do this by changing the audit level to 'all', audit level option can be found in the security tab of server properties.

 

[maswien]

If you use ODBC connection in access database, you can also use ODBC trace to log all the connections to ODBC trace log. To do that, goto ODBC manager and turn on ODBC trace.

 

[JohnBates]

One sure-fire way would be to take the database oof-line. R-click database name --> All tasks -->Take offline.
Wait for someone to call.

I use this technique sometimes, but mine is a small company.

John