Does anyone know if there is a similiar way to do database auditing like in Oracle. I have inherited a single MSSQLServer 7.0 Server that is running a large number of databases. I would like to be able to figure out which databases are being accessed and how often they are accessed. Any information would be greatly appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Auditing of Database Usage?
- Thread starter lancet22
- Start date
Start by running SQL Server Profiler (available from the SQLS program group) to get a feel for the kinds of things it can record. Robert Bradley
Got extra money lying around? Visit:
Got extra money lying around? Visit:
- Status
Similar threads
- Locked
- Question