Microsoft, SQL Server 2005, Data Analysis

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?

Thanks
Mike
michouisAsked:
Who is Participating?
 
Aneesh RetnakaranDatabase AdministratorCommented:
Log is not a table, it is a sequential file which you can trust as far as it is available there

Aneesh
0
 
David ToddSenior DBACommented:
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.

Regards
  David
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.