SQL Server Performance

Audit log

Discussion in 'SQL Server 2005 General DBA Questions' started by myworld, Aug 23, 2010.

  1. myworld New Member

    hi
    in sql 2005 how can i define Audit log for all those people who are access the specific Database
  2. melvinlusk Member

    You don't have many options here if you're using SQL Server 2005. You can use Login Auditing at the server level, which will track server logins in the Event Viewer. You could also enable C2 audit tracing, but this can be cumbersome.
    You could possibly try to define DDL triggers on some system tables, but this is very risky. You're best bet is to upgrade to SQL 2008 if possible.
  3. melvinlusk Member

    Another option is to use a 3rd party product, such as Lumigent Audit DB.
  4. satya Moderator

  5. myworld New Member

    thanks to u for your replay
    This Database should be kept in higher secure manner,then we need to keep monitoring , u have a sugestion in case of occasional need the information
  6. satya Moderator

Share This Page