Another frequently asked questions in the forums and newsgroups, I have seen similar ones recently. I believe most of the newbie users ask this question and even more as interview based questions. So here is the catch in order to accomplish the task, say you need to provide a solution to log and show all Create, read, update and delete ( CRUD ) transactions for auditing, this is more a mandatory for SOX & HIPPA regulations. Using the standard SQL Server methods which is an undocumented statement...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/tools/archive/2007/09/27/how-to-read-transaction-log.aspx