Microsoft, SQL Server 2005, Data Analysis

Posted on 2007-08-08
Last Modified: 2013-11-05
Is there any way to directly access/query a database transaction log file to produce information on WHO changed WHAT and WHEN. I have reviewed a product called Lumigent Log Explorer and it seems to have this feature but am I wrong in thinking that the log file is just another SQL table that I myself can query and get the same info. without Lumigent Log Explorer?

Question by:michouis
    LVL 75

    Accepted Solution

    Log is not a table, it is a sequential file which you can trust as far as it is available there

    LVL 35

    Expert Comment

    by:David Todd
    Hi Mike,

    Lumigent Log Explorer is one of a number of third party tools which offer this and similar features.

    Of course some of this auditing can be built into the product (and its tables), but takes more time etc.

    If your database is in simple recovery mode then the log is limited. ie things are there only until the next checkpoint. If you take log backups, then history prior to the log backup is no longer in the log, etc.


    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now