To be able get human readable transaction log you need to use some of the tool that decodes transaction log. Here is one
transaction log reader tool[
^] that can read transaction log and present you complete information stored in transaction log.
Other option is to try with
fn_dblog
but it also gives data in hex format that’s not really easy to read.
The reason transcation log can’t be read easily is because it’s not really meant to be read but to ensure transaction consitancy.