Windows 2003 and SQL 2008 Even Viewer Query

Question

Windows 2003 and SQL 2008 Even Viewer Query

BOR15K

SSCertifiable

Points: 5894
More actions
August 11, 2011 at 4:16 am

#255639

Hello techies!
I was asked if SQL 2008 can obtain a data from Windows 2003 Event Viewer (especially
Application's Error Level), but from a quick browsing haven't seen any information.
If it is possible, then the requirement will be to monitor the viewer for Errors and send
a request over the email.
Please advise, if it is doable and what would you recommend me to read in order to find more details.
Massive thanks in advance!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 1

Zeev Kazhdan (8/11/2011)
Hello techies!
I was asked if SQL 2008 can obtain a data from Windows 2003 Event Viewer (especially
Application's Error Level), but from a quick browsing haven't seen any information.
If it is possible, then the requirement will be to monitor the viewer for Errors and send
a request over the email.
Please advise, if it is doable and what would you recommend me to read in order to find more details.
Massive thanks in advance!

It is doable but not advisable! 😀

SQL Server is RDBMS and it is not designed for doing this sort of work at all.

There are dedicated tools availabe for notification of windows event.

Google for: windows event notification alert

You will find quite few of them.

Just included one as sample: http://www.manageengine.com/products/eventlog/event-alerting.html

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

BOR15K SSCertifiable Points: 5894 More actions · Answer 2

Thanks for your reply - it was the first thing I have asked as well.

An issue is that I am not allowed to bring any 3rd party tool as of security reasons,

so have to stick to the SQL, I am afraid.

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 3

Then you can tell your bosses to forget about it as in order to do it in SQLServer you will need to write your own tool yourself (c# or other) and call it from SQL. It's even more risky and it would be hard to find a DBA who would allow it on production server...

You can tell them also to learn that T-SQL is for data manipulation within database and nothing else. SQL Server is relational database management system and it has nothing to do with what they asking from it.

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

BOR15K SSCertifiable Points: 5894 More actions · Answer 4

Yes and No - I already had to use a SQL Server to perform HTTP POST commands

as a result of lack of knowledge of customer's .Net team and it works perfectly since.

So I agree that the core SQL Server is not for that, but when there is no other solution...