Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 DBCC LOG and transaction log file

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-07-09 : 00:52:29
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."
   

- Advertisement -