------=_NextPart_001_0003_01C1CE8E.BDB5A300
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I am writing a store procedure and want to have a system where in if the 
stored procedure fails I want it to notify me. How can I do it? Any help 
from any one very highly appreciated.
Thanks
SriGet more from the Web.  FREE MSN Explorer download : http://explorer.m
sn.com

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C1CEB8.7414A960
Content-Type: text/plain;
	charset="iso-8859-1"

You can check for errors in procedures using @@Error.  
 
-- SQL Statements
 
If @@Error != 0
Begin
-- Email procedure such as xp_sendmail
End 
            
 
Josh King
GeoAccess Inc.
xxx.xxx.xxxx  x5237
 
-----Original Message-----
From: Srinivasan Prasanna [mailto:Sri_Core@m...]
Sent: Monday, March 18, 2002 2:08 PM
To: ASP_ADO_RDS
Subject: [asp_ado_rds] SQL Stored Procedure to send an email.
 
I am writing a store procedure and want to have a system where in if the
stored procedure fails I want it to notify me. How can I do it? Any help
from any one very highly appreciated.
Thanks
Sri
--- 
To unsubscribe send a blank email to %%email.unsub%% 
--- 


  _____  

Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com
<http://explorer.msn.com>