Post reply

Audit Logging Option in Sql Server 2005

  • April 27, 2012 at 1:50 pm

    #146907

    I want to see history data for some tables in SQL Server.

    What will be the best way to store that data...

    Triggers...Sql Trace..etc...?

  • April 27, 2012 at 2:38 pm

    #1480701

    Do you want to see the historical values for the data?

    Do you want to see the DML that was performed?

    Do you want to see who it was that made the changes?

    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

  • April 27, 2012 at 7:23 pm

    #1480783

    I want to see the historical data and who has changed the data.

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

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