Home >> Dot Net Interview Questions >> Mix Dot Net Questions

How to read transaction Log in Sql

Posted on May 28th , 2009 by Admin

DBCC LOG([,{0|1|2|3|4}])

0 - Basic Log Information (default)

1 - Lengthy Info

2 - Very Length Info

3 - Detailed

4 - Full Example

and syntax is as follows

DBCC log(db,4)