Hany Helmy (3/11/2015)
Thanx 4 sharing the script, but if u have a common SQL login that is being used by an application accessed by many users, then it`s kind of useless unless u have other information like host name or IP address.
Well, that's a completely different story, I guess the log writes enough to redo a transaction when restored, so if it doesn't write that info (or maybe the function does not retrieve it), most probably is not required for the purpose.
You can check the available columns using this
SELECT TOP 1 *
EXECUTE tempdb..sp_help '#fn_dblog'