<p>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.</p>

<p>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..</p>

[{'answer_id': 50116, 'author': 'Robin Minto', 'author_id': 1456, 'author_profile': 'https://Stackoverflow.com/users/1456', 'pm_score': 5, 'selected': True, 'text': '<p>This is only relevant if you\'re talking SQL Server 2000 but RedGate produced a free tool called <a href="http://www.red-gate.com/products/SQL_Log_Rescue/index.htm" rel="noreferrer">SQL Log Rescue</a>.\nOtherwise, for SQL Server 2005 <a href="http://www.apexsql.com/sql_tools_log.asp" rel="noreferrer">ApexSQLLog</a> from ApexSQL is the only other product I\'m aware of</p>\n'}, {'answer_id': 50123, 'author': 'Espo', 'author_id': 2257, 'author_profile': 'https://Stackoverflow.com/users/2257', 'pm_score': 3, 'selected': False, 'text': '<p>You can use the undocumented <a href="http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1173464,00.html" rel="noreferrer">DBCC LOG  command.</a></p>\n'}, {'answer_id': 50125, 'author': 'Guy Starbuck', 'author_id': 2194, 'author_profile': 'https://Stackoverflow.com/users/2194', 'pm_score': 2, 'selected': False, 'text': '<p>There\'s a commercial product from Lumigent called "Log Explorer".  It\'s $995 per seat, but should cover your basic requirements.</p>\n'}, {'answer_id': 50131, 'author': 'SQLMenace', 'author_id': 740, 'author_profile': 'https://Stackoverflow.com/users/740', 'pm_score': 0, 'selected': False, 'text': '<p>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</p>\n'}, {'answer_id': 19081981, 'author': 'Ardalan Shahgholi', 'author_id': 2063547, 'author_profile': 'https://Stackoverflow.com/users/2063547', 'pm_score': 1, 'selected': False, 'text': '<p>you can use this query :</p>\n\n<pre><code>Select * from ::fn_dblog(null,null)\n</code></pre>\n\n<p>or see this link : <a href="https://stackoverflow.com/questions/4153514/how-can-i-view-sql-server-2005-transaction-log-file/19081839#19081839">How can I view SQL Server 2005 Transaction log file</a></p>\n\n<p>or this link : <a href="http://sqlfascination.com/2010/02/03/how-do-you-decode-a-simple-entry-in-the-transaction-log-part-1/" rel="nofollow noreferrer">How Do You Decode A Simple Entry in the Transaction Log? </a></p>\n'}]
['https://Stackoverflow.com/questions/50106', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/4337/']