|
Monitoring ErrorLogs in SQL Server can be done a number of ways, but if you want to scan the contents in SQL and use filters to SELECT specific events from the Error Log in TSQL, it has traditionally required creating a temporary table to hold the results of xp_readerrorlog and then running your selects against this temp table. This method requires a lot of code, and isn't a fast way to pull data on the fly. Now with SQL CLR and Table Valued Functions it is simple to create a permanent solution to this problem.
Read More..
|