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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 DBCC LOG and transaction log file
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Ask SQLTeam Question

0 Posts

Posted - 07/09/2001 :  00:52:29  Show Profile  Visit AskSQLTeam's Homepage  Reply with Quote
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
--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."

Slow But Sure Yak Herding Master

United Kingdom
3608 Posts

Posted - 07/09/2001 :  07:22:39  Show Profile  Reply with Quote
No, this is directly from the transaction log. Try using DBCC LOG(DBName,Option) Option being -1,0,1,2 or 3(I think these are all the values available). The Option part is how detailed you want the output. Takes a while to work out the meanings of each part of the log, but if you want an easier alternative, get Log Explorer from

The meanings are explained in the header, if you can't understand it then you definately need Log Explorer as DBCC LOG() is an UNDOCUMENTED feature of SQL, which i'm sure you would have been told...

Go to Top of Page

uri dimant
Starting Member

16 Posts

Posted - 07/10/2001 :  02:55:34  Show Profile  Reply with Quote
try undocumented command dbcc loginfo 'databasename'

Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000