寻找 SQL 事务日志文件查看器

如果你们中有人使用过很酷的工具来查看/查询 SQL 事务日志，请告诉我.这应该显示所有提交或回滚的事务性 sql 语句.

对于数据库文件，如果它有一些额外的图形功能，比如显示索引的内部二叉树结构，那会很棒，但我想我要求太多了吧..

解决方案

这仅适用于 SQL Server 2000 但 RedGate 生产了一个名为 SQL 日志救援.否则，对于 SQL Server 2005 ApexSQLLog 来自 ApexSQL 是我所知道的唯一其他产品

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