寻找一个SQL事务日志文件查看器 [英] Looking for a SQL Transaction Log file viewer

问题描述

如果您中有任何人使用了一款不错的工具来查看/查询SQL事务日志，请告诉我.这应该显示所有已提交或回退的事务性sql语句.

对于数据库文件，如果它具有一些其他图形功能(例如显示索引的内部二叉树结构)，那将是很棒的，但是我想我要求太多了..

解决方案

这仅在您正在使用SQL Server 2000时才有意义，但是RedGate提供了一个名为 ApexSQLLog 是我知道的唯一其他产品

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

这篇关于寻找一个SQL事务日志文件查看器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！