<html>
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered)">
<style>
<!--
font-face
{font-family:Tahoma;}
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
pre
{margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.emailstyle17
{font-family:Arial;
color:windowtext;}
span.EmailStyle19
{font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>I don’t understand. Can you elaborate
please?</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Petrucci, Joseph
[mailto:Joseph.Petrucci@ddiworld.com] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Tuesday, October 11, 2005
11:58 AM<br>
<b><span style='font-weight:bold'>To:</span></b> Forough, Hamid;
nagios-users@lists.sourceforge.net<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [Nagios-users] PLease
help</span></font></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> </span></font></p>
<div id=idOWAReplyText43136>
<div>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:black'>I do this with Sybase and it should still
work this way i MSSQL 2K.</span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> </span></font></p>
</div>
<div>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:black'>I would use a passive check (info on this
is in the manual) that reads the errorlog. Then you will have to have
your procedure execute a raiserror in the event of failure or any other message
you want. Have the plugin look at the error log for specific error numbers that
you define in the master.dbo.syserrors table (If there still is one) </span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> </span></font></p>
</div>
</div>
<div id=idSignature21269><pre><font size=2 face="Courier New"><span
style='font-size:10.0pt'>Joseph A. Petrucci</span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>E Systems DBA</span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>------------------------------------------------</span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>Desk: 412-220-2646</span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>Cell: 412-916-2867</span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>Text message (e-mail) 4129162867@mobile.att.net</span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>e-mail joseph.petrucci@ddiworld.com</span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>Personal Cell: 724-462-0443</span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>Personal e-mail: japetrucci@hotmail.com</span></font></pre></div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> </span></font></p>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabIndex=-1>
</span></font></div>
<p class=MsoNormal style='margin-bottom:12.0pt'><b><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
nagios-users-admin@lists.sourceforge.net on behalf of Forough, Hamid<br>
<b><span style='font-weight:bold'>Sent:</span></b> Tue 10/11/2005 11:45 AM<br>
<b><span style='font-weight:bold'>To:</span></b>
nagios-users@lists.sourceforge.net<br>
<b><span style='font-weight:bold'>Subject:</span></b> [Nagios-users] PLease
help</span></font></p>
</div>
<div>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I need to know how to write a custom plugin that checks
results of a stored procedure in MSSQL 2k and returns Yes or NO? I am using 2b4
verision of Nagios</span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> </span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> </span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> </span></font></p>
<p class=MsoNormal><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma'>Thanks,<br>
Hamid</span></font></p>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>Advanced Micro Devices</span></font></b></p>
<p class=MsoNormal><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma'><img width=108 height=29
src="cid:image001.gif@01C5CF0D.DEBE5FF0" border=0></span></font></p>
<p class=MsoNormal><font size=2 face=Tahoma><span lang=DE style='font-size:
10.0pt;font-family:Tahoma'>W: 512.602.4704<br>
C: 512.971-5345<br>
E: <a href="mailto:hamid.forough@amd.com">hamid.forough@amd.com</a></span></font><span
lang=DE><br>
</span></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> </span></font></p>
</div>
</div>
</body>
</html>