<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META content="MSHTML 6.00.2800.1106" name=GENERATOR></HEAD> <BODY> <DIV><SPAN class=927424316-12052003><FONT face=Arial size=2>Hello all,</FONT></SPAN></DIV> <DIV><SPAN class=927424316-12052003><FONT face=Arial size=2></FONT></SPAN> </DIV> <DIV><SPAN class=927424316-12052003><FONT face=Arial size=2>I would like to check an MS SQL 2000 database, and was wanting to know if there are any people out there doing this already.</FONT></SPAN></DIV> <DIV><SPAN class=927424316-12052003><FONT face=Arial size=2></FONT></SPAN> </DIV> <DIV><SPAN class=927424316-12052003><FONT face=Arial size=2>I know I can check the NT service with NSClient, but I wanted to do something a little more than that to make sure that the SQL service is indeed accepting requests and processing them.</FONT></SPAN></DIV> <DIV><SPAN class=927424316-12052003><FONT face=Arial size=2></FONT></SPAN> </DIV> <DIV><SPAN class=927424316-12052003><FONT face=Arial size=2>My idea was to have an ODBC connection from the nagios box to the MS SQL box and process the following:</FONT></SPAN></DIV> <DIV><SPAN class=927424316-12052003><FONT face=Arial size=2></FONT></SPAN> </DIV> <DIV><SPAN class=927424316-12052003><FONT face=Arial size=2>1 - read data from a table</FONT></SPAN></DIV> <DIV><SPAN class=927424316-12052003><FONT face=Arial size=2>2- write new data to a table</FONT></SPAN></DIV> <DIV><SPAN class=927424316-12052003><FONT face=Arial size=2>3 - read the new data from a table to make sure that it worked</FONT></SPAN></DIV> <DIV><SPAN class=927424316-12052003><FONT face=Arial size=2>4 - delete data from the table</FONT></SPAN></DIV> <DIV><SPAN class=927424316-12052003><FONT face=Arial size=2>5 - read the table again to make sure that the data is gone.</FONT></SPAN></DIV> <DIV><SPAN class=927424316-12052003><FONT face=Arial size=2></FONT></SPAN> </DIV> <DIV><SPAN class=927424316-12052003><FONT face=Arial size=2>any ideas if something like this exists before I go down the road of trying to create my own script with unix ODBC and all that???</FONT></SPAN></DIV> <DIV><SPAN class=927424316-12052003><FONT face=Arial size=2></FONT></SPAN> </DIV> <DIV><SPAN class=927424316-12052003><FONT face=Arial size=2>Thanks for the help..</FONT></SPAN></DIV> <DIV><SPAN class=927424316-12052003></SPAN><FONT face=Arial color=#0000ff size=2>____________________</FONT> <BR><FONT face=Arial color=#000000 size=2>Ian Farr</FONT> <BR><FONT face=Arial color=#000000 size=2>Director of Network Infrastructure</FONT> <BR><FONT face=Arial color=#000000 size=2>Oceanwide.com</FONT> <BR><FONT face=Arial color=#000000 size=2>514-289-9090 ext 234</FONT> </DIV> <DIV> </DIV></BODY></HTML>