SQLTeam.com | Weblogs | Forums

Monitoring/Log access to a Database

what possibilities there are to monitors access to a database. It is to be recorded, which user or client accesses it. And not on all tables, only tables to a certain scheme.
Background: The database will soon be switched off...
Thanks and
Nicole :wink:

you can use SQL Trace to log any activity on that database