January 7, 2008 at 6:57 am
Hi,
Please could i have some help,
is it possible to access Windows Event Viewer from SQL,
or is it possible to filter the event viewer, to give me
a notification of when an error is detected or for a warning...
Thanks TG
January 7, 2008 at 7:09 am
You can set up some monitoring using alerts to look for certain events to fire, but not necessarily all Windows events. If you need something that occurs in Windows, use an event monitoring system outside of SQL Server.
January 7, 2008 at 7:53 am
"is it possible to access Windows Event Viewer from SQL?"
Not directly, but the Log Parser utility can be used to load the windows event log into a SQL Server table.
SQL = Scarcely Qualifies as a Language
January 7, 2008 at 7:54 am
SQL 2005 gives you a wide range of options for setting up custom alerts, including Windows errors (I believe). If you right-click Alerts and setup a new alert, under the type option you have the following options:
SQL Server event alert
SQL Server performance condition alert
WMI event alert
I believe WMI event alert is what you want but you'd have to write custom queries to get what you want. Hope this helps somewhat.
=============================================================
/* Backups are worthless, Restores are priceless */
Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management
January 10, 2008 at 6:48 am
Thanks Guys,
im testing the WMI Event Alert,
will let you know how it goes.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply