If any of you have worked with a cool tool for viewing/querying the SQL Transaction logs, please let me know. This should show all the transactional sql statements which are committed or rolled back.
For Database files, if it has some additional graphical capabilities like showing the internal Binary Tree structure of the indexes, that will be awesome but I guess I am asking for too much huh..
This is only relevant if you're talking SQL Server 2000 but RedGate produced a free tool called SQL Log Rescue.
Otherwise, for SQL Server 2005 ApexSQLLog from ApexSQL is the only other product I'm aware of
There's a commercial product from Lumigent called "Log Explorer". It's $995 per seat, but should cover your basic requirements.
There are some companies that produce log readers like Lumigent and Red Gate. However they do not work with SQL server versions greater than 2000 because of meta data changes in the underlying system tables and data types, they might work if you do not use any new functionality but if you use varchar(max) XML datatype etc you are out of luck