MHB writes "Dear Expert
I want to know how can I see SQL Server 7 transaction log files
for example I want to know User1 Updates/Adds/Deletes which rows of
which tables and when?
is there T-SQL or any other way to this purpose?
an expert suggest to me
DBCC log(PRS)
--prs is my DataBase
I wrote this statement in 'Query Analyzer MS Sql server 7'
and I 've get this statements
Current LSN Operation Context Transaction ID
---------------------- ------------------ ------------------ --------------
00000005:0000001e:0001 LOP_BEGIN_CKPT LCX_NULL 0000:00000000
00000005:0000001f:0001 LOP_END_CKPT LCX_NULL 0000:00000000
00000005:00000020:0001 LOP_BEGIN_XACT LCX_NULL 0000:00000126
00000005:00000020:0002 LOP_DELETE_ROWS LCX_MARK_AS_GHOST 0000:00000126
00000005:00000020:0003 LOP_SET_FREE_SPACE LCX_PFS 0000:00000126
00000005:00000020:0004 LOP_MODIFY_HEADER LCX_PFS 0000:00000126
00000005:00000020:0005 LOP_DELETE_ROWS LCX_HEAP 0000:00000126
00000005:00000020:0006 LOP_DELTA_SYSIND LCX_CLUSTERED 0000:00000126
00000005:00000020:0007 LOP_COMMIT_XACT LCX_NULL 0000:00000126
00000005:00000022:0001 LOP_BEGIN_XACT LCX_NULL 0000:00000127
00000005:00000022:0002 LOP_MODIFY_HEADER LCX_PFS 0000:00000127
00000005:00000022:0003 LOP_EXPUNGE_ROWS LCX_INDEX_LEAF 0000:00000000
00000005:00000022:0004 LOP_SET_FREE_SPACE LCX_PFS 0000:00000127
00000005:00000022:0005 LOP_COMMIT_XACT LCX_NULL 0000:00000127
00000005:00000023:0001 LOP_BEGIN_XACT LCX_NULL 0000:00000128
00000005:00000023:0002 LOP_DELETE_ROWS LCX_MARK_AS_GHOST 0000:00000128
00000005:00000023:0003 LOP_SET_FREE_SPACE LCX_PFS 0000:00000128
00000005:00000023:0004 LOP_MODIFY_HEADER LCX_PFS 0000:00000128
00000005:00000023:0005 LOP_DELETE_ROWS LCX_HEAP 0000:00000128
00000005:00000023:0006 LOP_DELTA_SYSIND LCX_CLUSTERED 0000:00000128
00000005:00000023:0007 LOP_COMMIT_XACT LCX_NULL 0000:00000128
00000005:00000025:0001 LOP_BEGIN_XACT LCX_NULL 0000:00000129
00000005:00000025:0002 LOP_MODIFY_HEADER LCX_PFS 0000:00000129
00000005:00000025:0003 LOP_EXPUNGE_ROWS LCX_INDEX_LEAF 0000:00000000
00000005:00000025:0004 LOP_SET_FREE_SPACE LCX_PFS 0000:00000129
00000005:00000025:0005 LOP_COMMIT_XACT LCX_NULL 0000:00000129
(26 row(s) affected)
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
How can I use them ? what is the meaning of colomn of this query?how can I reach out to meaning of them?are
they in a table of sql server ?
Thank you for your complete answer."
DBCC LOG and transaction log file
Posted - 07/09/2001 : 00:52:29
