Regarding Audits in sql server

  • Hi All,

    I'm using Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Developer Edition on Windows NT 6.1 <X86> (Build 7600: )

    how to apply the audit logs on the tables. Please tell me the procedure or suggest me any links.

    Thanks in Advance,

    Avinash P

  • It really depends on what you're attempting to audit. If you want to see data changes, the best bet is to implement change data capture (CDC). If you want to see who is logging in and/or making changes, you'll need to implement either extended events (my preference) or trace events[/url]. Not knowing specifically what you're looking for, that's about all I can say.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • p.avinash689 (2/4/2014)


    Hi All,

    I'm using Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Developer Edition on Windows NT 6.1 <X86> (Build 7600: )

    how to apply the audit logs on the tables. Please tell me the procedure or suggest me any links.

    Thanks in Advance,

    Avinash P

    How wide are the tables in columns?

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Here is a product that covers just about the entire gambit for audit purposes...

    http://www.beyondtrust.com/Products/PowerBrokerDatabases/

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Jeff Moden (2/4/2014)


    p.avinash689 (2/4/2014)


    Hi All,

    I'm using Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Developer Edition on Windows NT 6.1 <X86> (Build 7600: )

    how to apply the audit logs on the tables. Please tell me the procedure or suggest me any links.

    Thanks in Advance,

    Avinash P

    How wide are the tables in columns?

    Can't help if I can't get information from you.

    If your tables are more than 30 or so columns, use "field level" audit tables. Otherwise, use "row level" auditing.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 5 posts - 1 through 4 (of 4 total)

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