There is a need to find a tool to query the SQL Server history operation log, such as accidental deletion, misoperation, etc., online search a lot, not a reliable. Of course, exclude themselves from writing SQL records operation log, I do not understand the SQL language. There are tools available to recommend, thank you.
Log Explorer for SQL Server
Support to SQL2005, the above is not supported.
SQL Server comes with management--sql server logs
Logged in and error logs
Powerful SQL Server Profiler
Mainly as a real-time analysis process or troubleshooting to use, can not query the history log, unless always open
Query transaction log, restore LSN, this too high-end
Refer to http://blog.csdn.net/kevinsqlserver/article/details/7800628
More powerful third-party tools, ApexSQL Log,
Display effect is good, easy to understand, but the trial can only query the last 10 rows of log, to solve
SQL Server's own auditing capabilities
Available, I feel most reliable at the moment. Simple configuration is required and is not audited by default.
Http://technet.microsoft.com/zh-cn/library/cc280386.aspx
Expect Microsoft to be able to open a tool that can view the LDF, otherwise this file will be used
This article from "CLOUD" blog, declined reprint!