Post reply

what is an audit trail used for in transaction? how is different from save point?

  • November 17, 2005 at 1:49 am

    #169493

    1.what is an audit trail used for in transaction? how is different from save point?

     

     

    2.i read the transaction log cannot be read without 3rd party software such as Lugiment. but recently i read a function or command that read the log. can you use a t-sql command to read the log or do u need 3rd party software??

     

    thanks

  • November 17, 2005 at 6:06 am

    #604393

    1.) Can you explain more about the specific situation? I don't see how the term 'audit trail' relates to 'transaction'... You can read about save points (what they are and how they work) in BOL under the subject(s) that deal with transactions and transaction handling.

    2.) AFAIK, if you want to read something itelligble from the log, you need 3rd party software.

    /Kenneth

  • November 17, 2005 at 7:41 am

    #604413

    There are ways with DBCC to read the log, but it's not easy to do, or easy to interpert. The third party products are worth the $$ easily and it's not that many. You couldn't come close to reliably building something for the price they charge.

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

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