Transaction Log

[DBAWinnipeg]

Can you query the transaction Log

This is in relation to a previous post of mine asking about when a block or deadlock occurs being able to see the statement that caused the lock.

My theory... if I can associate the locking process to the transaction log I should be able to pull the last "REAL" transaction.

DBCC INPUT BUFFER doesn't always give me what I'm looking for.

So any ideas on that? (querying the transaction log)



Thanks in advance!!!

Colin in da 'Peg

 

[SQLBill]

Nope. Can't read the transaction log (not really) unless you buy a third party tool. There is a command DBCC LOG() that provides info from the current database, but it's mostly worthless for evaluating activity.

-SQLBill

 

[nigelrivett]

Try using the profiler.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[DBAWinnipeg]

Nigelrivett

That would require me to have a trace running 24/7 and that is what I was hoping to avoid.

Thanks in advance!!!

Colin in da 'Peg

 

[almoes]

Sorry nigelrivett, but you mean that I am able to read the transaction log file with the profiler? If yes how? thanxs!

cheers,
alej