Consolidating SQL Server Error Logs from Multiple Instances Using SSIS

Posted on SQL Server Central See other posts from SQL Server Central
Published on 2010/04/28 Indexed on 2010/04/28 6:04 UTC
Read the original article Hit count: 242

Filed under:
SQL Server hides a lot of very useful information in its error log files. Unfortunately, the process of hunting through all these logs, file-by-file, server-by-server, can cause a problem. Rodney Landrum offers a solution which will allow you to pull error log records from multiple servers into a central database, for analysis and reporting with T-SQL.

© SQL Server Central or respective owner