February 17, 2003 at 2:01 pm
I've been taking a look at this undocumented command DBCC Log that can be used to view the current tran log, it retrieves a lot of info, just wondering if anyone knows if there is somewhere that explains what some of this data really is? Also if a select statement is contained in a stored proc and is executed within the context of a transaction is it logged to the tran log?
Thanks
E...
February 17, 2003 at 2:54 pm
BOL 2000 : Every Microsoft® SQL Server™ 2000 database has a transaction log that records all transactions and the database modifications made by each transaction.
1)Recovery of individual transactions.
2)Recovery of all incomplete transactions when SQL Server is started.
3)Rolling a restored database forward to the point of failure
An individual select do not modify the database as such, except combined with inserts and I do not it will not be logged.
Opcodes
0=BEGINXACT
4=Insert
5=Delete
6=Indirect Insert
7=Index Insert
8=Index Delete
9=MODIFY
11=Deferred Insert (NO-OP)
12=Deferred Delete (NO-OP)
13=Page Allocation
15=Extent Allocation
16=Page Split
17=Checkpoint
20=DEXTENT
30=End Transaction
38=CHGSYSINDSTAT
39=CHGSYSINDPG
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply