Post reply

Audit SQL Server

  • July 2, 2009 at 4:29 pm

    #211643

    What is audit SQL Server and how can we do thatin SQL 2000 and SQL 2005?

    Please help....I have Phone interview tomorrow and requirement is Mostly on "Support SQL Server Team in all audit action plan tasks"

    Please anybody help me how to answer this question?

    Thanks in advance

  • July 3, 2009 at 4:20 pm

    #1019883

    There are several ways to achieve this in SQL Server 2000 - C2 level auditing or implementing third party tools. However, SQL Server 2005 introduced a new feature called DDL triggers to satisfy the Sarnes-Oxley.

    Triggers are not new to SQL Server. But prior to SQL Server 2005 triggers were DML triggers, which were raised only when there is an INSERT,UPDATE or DELETE action. A new table, database or user being created raises a DDL event and to monitor those, DDL triggers were introduced in SQL Server 2005.

    http://www.sql-server-performance.com/articles/audit/ddl_triggers_p1.aspx

    MJ

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply