DBCC Log info

[Sabnac]

Hi,
i am looking for informations about the undocumented command DBCC Log.
I already know the command and its differents options but i would like to know the meaning of the ouput columns (context, slot id, flag bit, ...)
Thx

 

[tlbroadbent]

I've never found much info regarding DBCC LOG output. Since we have purchased Lumigent Log Explorer, I don't have any need. Sorry I can't help.

I have found that SQL 2000 includes a function named fn_dblog that also dumps the transaction log or at least some portion of it. It appears to give more info than DBCC LOG but I'm not even sure about that. Unfortnately, it is also undocumented.

Usage is as follows. I don't know what parameter values are acceptable or how different params affect output. Perhaps, someone can enlighten us.

Select * from ::fn_dblog(null,null) If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[Sabnac]

Thx for your response, i've try the function and some infos are usefull like begin and end transaction time.

 

[Sabnac]

Params are the start LSN, and end LSN for filtering rows