DBCC log ( dbname, 0|1|2|3|4 )
where
0: minimum information (Default)
1: Returns info available using 0 + flags, tags and the log record length.
2: Returns info available using 1 + object, index, page ID and slot ID.
3: Maximum information about each operation.
4: Maximum information about each operation + hexadecimal dump of the current transaction log row
In order to run this command against a database called 'PictureAlbum' :-
DBCC LOG(PictureAlbum, 3)
OUTPUT:
No comments:
Post a Comment