August 25, 2010 at 5:51 am
Hi All !
i would like to view the transactions done with the Database and the log times for the same.
its SQL 2008 DB.
Also plz confirm, i hope even when a record is added via insert statement a log ll be created.
Thanks,
SD.
August 25, 2010 at 5:55 am
Why? What problem are you trying to solve here?
All data modifications are logged in the transaction log, but it is not intended as an audit log, it's not easily readable.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 25, 2010 at 8:08 am
If you are willing to spend some serious money, you can buy a log reader that can do what you are asking for -- but you need a knowledgable DBA to use it and interpret it; it isn't simple and easy for non-DBAs to read. Out of the box, you can't look at the log except via some arcane and undocumented commands and the information returned is not easy to interpret. Certainly nothing like you are seeking.
August 25, 2010 at 10:47 am
True, you can't read transaction log.
There's a tool you can download as trial to read (and alot more) <<www.apexsql.com>> the log. Reverse transactions etc. I find it very helpful.
Also, look into setting up audit. SQL Server 2008 has great features in creating audit logs, you can capture all statements agains a table. Unlike 2005 version, you can setup an audit in one place and not have to use multiple technologies such as DDL triggers etc.
Feel free to write to me if you need more help.
August 25, 2010 at 12:17 pm
Humayoon Khan (8/25/2010)
True, you can't read transaction log.
You can. It's not easy to understand, but you can.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply