DBCC TRACE FLAG 4032 
Author Message
 DBCC TRACE FLAG 4032
A ticketing appln of my customer has a double booking problem.
In order to help them diagnose the problem,
I captured the statements using dbcc trace flag 4032.

The statements captured do not reflect a rollback occured.
Without a rollback, it would not be possible to update the same seat twice.

MY question is
- would the above traceflag capture a rollback by the server !
- any other number i shd turn on.
- any third party tool i could use instead.

I'm using sql 6.0, so sql trace is out of the qn, no ?

Thanks.



Mon, 15 Jan 2001 03:00:00 GMT
 DBCC TRACE FLAG 4032

A ticketing appln of my customer has a double booking problem.
In order to help them diagnose the problem,
I captured the statements using dbcc trace flag 4032.

The statements captured do not reflect a rollback occured.
Without a rollback, it would not be possible to update the same seat twice.

MY question is
- would the above traceflag capture a rollback by the server !
- any other number i shd turn on.
- any third party tool i could use instead.

I'm using sql 6.0, so sql trace is out of the qn, no ?

Thanks.



Mon, 15 Jan 2001 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. DBCC trace flags

2. Undocumented DBCC and TRACE FLAGS

3. Trace flag for log in/out tracing

4. Trace flags 1204 and 3605

5. Trace flag 208, followed by server hang

6. Undoc'ed trace flags (208 specifically)

7. Trace Flags

8. trace flag 1204

9. Trace Flags for Blocking Locks?

10. Deadlock trace flag 1204 dump

11. investigating deadlocks without using trace flag 1204 ?

12. Trace flags


 
Powered by phpBB® Forum Software