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.
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 filesfor example I want to know User1 Updates/Adds/Deletes which rows ofwhich 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 DataBaseI wrote this statement in 'Query Analyzer MS Sql server 7'and I 've get this statementsCurrent LSN Operation Context Transaction ID ---------------------- ------------------ ------------------ -------------- 00000005:0000001e:0001 LOP_BEGIN_CKPT LCX_NULL 0000:0000000000000005:0000001f:0001 LOP_END_CKPT LCX_NULL 0000:0000000000000005:00000020:0001 LOP_BEGIN_XACT LCX_NULL 0000:0000012600000005:00000020:0002 LOP_DELETE_ROWS LCX_MARK_AS_GHOST 0000:0000012600000005:00000020:0003 LOP_SET_FREE_SPACE LCX_PFS 0000:0000012600000005:00000020:0004 LOP_MODIFY_HEADER LCX_PFS 0000:0000012600000005:00000020:0005 LOP_DELETE_ROWS LCX_HEAP 0000:0000012600000005:00000020:0006 LOP_DELTA_SYSIND LCX_CLUSTERED 0000:0000012600000005:00000020:0007 LOP_COMMIT_XACT LCX_NULL 0000:0000012600000005:00000022:0001 LOP_BEGIN_XACT LCX_NULL 0000:0000012700000005:00000022:0002 LOP_MODIFY_HEADER LCX_PFS 0000:0000012700000005:00000022:0003 LOP_EXPUNGE_ROWS LCX_INDEX_LEAF 0000:0000000000000005:00000022:0004 LOP_SET_FREE_SPACE LCX_PFS 0000:0000012700000005:00000022:0005 LOP_COMMIT_XACT LCX_NULL 0000:0000012700000005:00000023:0001 LOP_BEGIN_XACT LCX_NULL 0000:0000012800000005:00000023:0002 LOP_DELETE_ROWS LCX_MARK_AS_GHOST 0000:0000012800000005:00000023:0003 LOP_SET_FREE_SPACE LCX_PFS 0000:0000012800000005:00000023:0004 LOP_MODIFY_HEADER LCX_PFS 0000:0000012800000005:00000023:0005 LOP_DELETE_ROWS LCX_HEAP 0000:0000012800000005:00000023:0006 LOP_DELTA_SYSIND LCX_CLUSTERED 0000:0000012800000005:00000023:0007 LOP_COMMIT_XACT LCX_NULL 0000:0000012800000005:00000025:0001 LOP_BEGIN_XACT LCX_NULL 0000:0000012900000005:00000025:0002 LOP_MODIFY_HEADER LCX_PFS 0000:0000012900000005:00000025:0003 LOP_EXPUNGE_ROWS LCX_INDEX_LEAF 0000:0000000000000005:00000025:0004 LOP_SET_FREE_SPACE LCX_PFS 0000:0000012900000005: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." |
|
|
|
|