[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Microsoft, SQL Server 2005, Data Analysis

Posted on 2007-08-08
Medium Priority
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

Aneesh Retnakaran earned 500 total points
ID: 19656720
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
ID: 19659344
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

834 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