DBCC LOG and transaction log file

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."

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources