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.
you need to buy 3rd party products, such as Lumigent's log explorer, to be able to view the contents of the log.
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.
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?
