Saturday, December 10, 2011

How To View Transaction Log In SQL Server - SQL Server Transaction Log Viewer

You can use the following undocumented DBCC command for reading the transaction log information.

DBCC log (AdventureWorks, 0)
DBCC log (AdventureWorks, 1)
DBCC log (AdventureWorks, 2)
DBCC log (AdventureWorks, 3)
DBCC log (AdventureWorks, 4) 

'0' is for basic Log Information (default) 
'1' is for lengthy Info 
'2' is for very Length Info 
'3' is for detailed 
'4' is for full 

Example: In this example i am using full (4), if you want only limited information then you can go for 0. 

DBCC log (AdventureWorks, 4) 

And it displays the following transaction log information: 
1. Current LSN 
2. Operation (string starts with LOP_XXXXX) 
3. Context (string starts with LCX_XXXX) 
4. Transaction ID 
5. Tag Bits (Hex) 
6. Log Record Fixed Length (int) 
7. Log Record Length (int) 
8. Previous LSN 
9. Flag Bits (Hex) 
10. Description (string) 
11. Log Record (Hex)





Looking for a SQL Transaction Log file viewer, How to view transaction log for SQL Server 2005, How to view transaction log for SQL Server 2008. How to view transaction log for SQL Server 2012. SQL Server transaction log reader, Transaction Log Viewer - Internals Viewer for SQL Server , How to view transaction log, How to view transaction log, Log Viewer, The transaction log for database, view the content ldf file, What's In A SQL Transaction Log File, how to check the transaction log inside, Viewing the Transaction Log, transaction log viewer 2008, sql transaction log viewer 2008, sql transaction log viewer free, sql server transaction log viewer free, sql server transaction log viewer microsoft, t sql transaction log viewer
transaction log viewer sql 2012, transaction log viewer sql server 2005

1 comments:

Post a Comment