If you are still not sure if LogViewer is right for your database tool kit, below are just a few examples of how LogViewer can work for you.
Suppose your database went down last night. The first questions that come to mind are "Why did it fail?" and "Who or What caused the failure?". Stop the guessing game. Find out exactly which applications and users were using your data environment at the time of failure, what objects they were working on, and what actions they were taking.
Suppose data was deleted from a table or unwantingly changed (either maliciously or accidentally). LogViewer enables you to track down the command that was executed, the time it occurred, and the guilty application that executed the command. Overall enabling the developer or DBA to take proactive steps to minimize the potential of this happening again.
Sometimes when debugging your data driven applications finding the root of the problem is like finding the proverbial needle in a haystack. With LogViewer you can view the exact interaction that your code is having with your database. Powerful filters enable users to key on the application of choice.
At times DBA's need access to historical data that has been changed or deleted. With most backup devices recalling specific data is a nightmare, typically you must restore the entire database just to get at the granular historical data needed. LogViewer reads your transaction logs which include historical data (unless you have truncated your log). With LogViewer's robust search features you can locate the exact record data you need quickly.
Need to increase your database auditing efforts? Whether you are under pressure of increased regulatory compliance demands, new data privacy requirements, or one of the many other reasons for auditing, LogViewer is the perfect tool to strengthen your auditing plan. LogViewer gives you a direct look at exactly what changes are taking place within your data environment. SQL Server by default records all database altering actions within the transaction log, LogViewer makes this goldmine of auditing data available to you.
