恭喜几位MVP！有个问题，微软有没有提供查看SQL SERVER 日志的工具？第三方软件除了Log Explorer还有别的工具吧？

[spring_ok]

RT

[伍子V5]

我也就知道这一个，帮你UP

[hydonlee]

请问楼主:
Log Explorer好用吗?

[zjcxc]

据我所知,微软没有.

第三方软件我知道的也只有:Log Explorer

[leimin]

DBCC log

This command is used to view the transactional log for the specified
database.

Syntax:

DBCC log ( {dbid|dbname}, [, type={-1|0|1|2|3|4}] )


PARAMETERS:
Dbid or dbname - Enter either the dbid or the name of the database
in question.

type - is the type of output:

0 - minimum information (operation, context, transaction id)

1 - more information (plus flags, tags, row length, description)

2 - very detailed information (plus object name, index name,
page id, slot id)

3 - full information about each operation

4 - full information about each operation plus hexadecimal dump
of the current transaction log's row.

-1 - full information about each operation plus hexadecimal dump
of the current transaction log's row, plus Checkpoint Begin,
DB Version, Max XDESID

by default type = 0

To view the transaction log for the master database, you can run the
following command:

DBCC log (master)

[spring_ok]

Thanks.

But how can you figure out the "DBCC Log (MASTER)" query result like the following?

0000000c:00001cf4:0022 LOP_DELETE_ROWS LCX_CLUSTERED 0000:00000bb2
0000000c:00001cf4:0023 LOP_INSERT_ROWS LCX_CLUSTERED 0000:00000bb2
0000000c:00001cf4:0024 LOP_MODIFY_ROW LCX_TEXT_MIX 0000:00000bb2
0000000c:00001cf4:0025 LOP_MODIFY_ROW LCX_TEXT_MIX 0000:00000bb2

[sdhdy]

是啊，确实不好看！

[goodboycwy]

其他的o还没有见到过，log explorer不过很好用，图形界面，对于我们来说，应该是“easy”