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