SQL Server Performance

T-Log

Discussion in 'Getting Started' started by anchor, Sep 20, 2007.

  1. anchor New Member

    Hi Gurus, I am agaim I hope I am not giving you guys tough time.
    Can anyone please help me how to check the transaction log. My doubt was can we see all the transactions logs in the form of table. And what are the different ways to check the causes for a job failure.
    Thanks in Advance. Forgive me if my questiosn are too basics.
  2. thomas New Member

    you need to buy 3rd party products, such as Lumigent's log explorer, to be able to view the contents of the log.
  3. bradmcgehee New Member

    There is a command in SQL Server to view the log, but it returns mostly useless information. Other third-party log viewing tools are available from www.apexsql.com and www.red-gate.com. Try them all out before you make a purchase decision, as each one offers different features.
  4. satya Moderator

    This has been asked here many times before, as suggested using native SQL way is not achieveable and you may not be able to understand the format.
    BTW what is your requirement and why you need to view the transaction log?

Share This Page