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...
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
Thu, Sep 27 2007
Filed under: sql server, ssms, tools, transaction log, dba, read, access, audit, log file, third party, resolution