寻找 SQL 事务日志文件查看器
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/50106/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Looking for a SQL Transaction Log file viewer
提问by Gulzar Nazim
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.
如果你们中有人使用过很酷的工具来查看/查询 SQL 事务日志，请告诉我。这应该显示所有提交或回滚的事务性 sql 语句。
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..
对于数据库文件，如果它有一些额外的图形功能，比如显示索引的内部二叉树结构，那会很棒，但我想我要求太多了哈..
采纳答案by Robin Minto
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 ApexSQLLogfrom ApexSQL is the only other product I'm aware of
这仅在您谈论 SQL Server 2000 时才有意义，但 RedGate 生产了一个名为SQL Log Rescue的免费工具。否则，对于 SQL Server 2005，来自 ApexSQL 的ApexSQLLog是我所知道的唯一其他产品
回答by Espo
You can use the undocumented DBCC LOG command.
您可以使用未记录的DBCC LOG 命令。
回答by Guy Starbuck
There's a commercial product from Lumigent called "Log Explorer". It's $995 per seat, but should cover your basic requirements.
Lumigent 有一个名为“Log Explorer”的商业产品。每个座位 995 美元，但应该满足您的基本要求。
回答by Ardalan Shahgholi
you can use this query :
您可以使用此查询：
Select * from ::fn_dblog(null,null)
or see this link : How can I view SQL Server 2005 Transaction log file
或查看此链接：如何查看 SQL Server 2005 事务日志文件
or this link : How Do You Decode A Simple Entry in the Transaction Log?
或此链接：如何解码事务日志中的简单条目？
回答by SQLMenace
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
有一些公司生产日志阅读器，如 Lumigent 和 Red Gate。但是，由于底层系统表和数据类型中的元数据更改，它们不适用于大于 2000 的 SQL 服务器版本，如果您不使用任何新功能，它们可能会起作用，但如果您使用 varchar(max) XML 数据类型等，您是不走运
