！！怎样查询日记记录！！！

[gechaosa]

在SQL不用第三方工具，怎样查询日记（LOG）记录，

[lift0]

高手快解决

[zjcxc]

SQL7.0找不到对应的办法

[jiangchuandong]

我也是操作的2000系统

[zjcxc]

select * from ::fn_dblog(null,null)

[gechaosa]

我试了在sql97
但不能执行，结果如下：
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near ':'.

[jiangchuandong]

可以的，我刚才试过

[jiangchuandong]

查询northwind的结果
Current LSN Operation Context Transaction ID Tag Bits Log Record Length Previous LSN Flag Bits Object Name Index Name Page ID Slot ID Previous Page LSN Offset in Row Num Elements Element Element Length Offset Row Data Checkpoint Begin CHKPT Begin DB Version Max XDESIDNum Transactions Transaction Ctr Transaction ID in CHKPT Transaction Status CHKPT Begin LSN Transaction State Transaction Type Last LSNRecord Count Bytes Used Bytes Reserved Checkpoint EndCHKPT End DB Version Minimum LSN Dirty Pages Oldest Replicated Begin LSN Next Replicated End LSN Last Distributed Backup End LSN Last Distributed End LSN Server UID UID SPID Beginlog Status Begin Time Transaction NameEnd Time Transaction Begin Replicated Records Oldest Active LSN Server Name Database Name Mark Name Master XDESID Master DBID Preplog Begin LSN Prepare Time Previous SavepointSavepoint Name Rowbits First Bit Rowbits Bit Count Rowbits Bit Value LSN before writes Pages Written Page Counter Bufwrite Page Id Data Pages Delta Reserved Pages Delta Used Pages Delta Data Rows Delta Command Type Publication ID Article ID Partial Status Command Byte Offset New Value Old Value New Split Page Rows Deleted Bytes Freed CI Table Id CI Index Id FileGroup ID
---------------------- ------------------------- ------------------------- -------------- -------- ----------------- ---------------------- --------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------- ------------- ------- ---------------------- ------------- ------------ ------- -------------- ------ ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------- ---------------------- -------------- ---------------- --------------- ----------------------- ------------------ ---------------------- -------------------- ---------------- ---------------------- ------------ ----------- -------------- ----------------------- -------------------- ---------------------- ----------- --------------------------- ----------------------- ------------------------------- ------------------------ ----------- ----------- ----------- --------------- ----------------------- -------------------- ----------------------- ---------------------- ------------------ ---------------------- -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- -------------------------------- -------------- ----------- ---------------------- ----------------------- ---------------------- -------------------- ----------------- ----------------- ----------------- ---------------------- ------------- ------------ ---------------- ---------------- -------------------- ---------------- --------------- ------------ -------------- ----------- -------------- -------------------------------------------------------------------------------------------------------------------------------- ----------- --------- --------- -------------- ------------ ----------- ----------- ----------- ------------
0000001a:000000a0:0001 LOP_BEGIN_CKPT LCX_NULL 0000:00000000 0x0000 96 00000019:00000080:0001 0x0000 NULL NULL NULLNULL NULL NULLNULL NULL NULL NULL NULL2004/03/25 19:06:10:580 5390000:0000101a NULL NULL NULLNULLNULL NULL NULL NULL NULL NULL NULL NULLNULL NULL NULL NULL NULLNULL NULL NULL NULL NULL NULL NULLNULL NULLNULL NULLNULL NULLNULLNULL NULL NULL NULL NULLNULL NULL NULL NULL NULL NULL NULLNULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULLNULL NULL NULL NULL NULL NULL NULL NULL NULL
0000001a:000000a1:0001 LOP_END_CKPT LCX_NULL 0000:00000000 0x0000 1360000001a:000000a0:0001 0x0000 NULL NULL NULLNULL NULL NULLNULL NULL NULL NULL NULLNULLNULL NULL NULL NULL NULLNULLNULL NULL NULL NULL NULL NULL NULL 2004/03/25 19:06:10:670 539 0000001a:000000a0:0001 6 00000000:00000000:0000 00000000:00000000:0000 00000000:00000000:000000000000:00000000:0000 NULL NULL NULL NULL NULLNULL NULLNULL NULLNULL NULLNULLNULL NULL NULL NULL NULLNULL NULL NULL NULL NULL NULL NULLNULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULLNULL NULL NULL NULL NULL NULL NULL NULL NULL

那位老大能解释一下吗？