Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Yeah sounds like it should work...
As Sergy and Mike suggested, you might want to look into using the xp_logevent or the xp_sendmail stored procedures. They are both well documented in the BOL and might make it simpler to set up.
Eric
>So I need to do three things?
>
>1) Create an error message with number > 50000 in the sysmessages since this condition is something I will be testing for constantly.
>
>2) Create an alert than fires when the error message I created is written to the log. Set up the alert with my email.
>
>3) Modify my SP to do a raiseerror with my newly made message code and give it a severity of 19 so that it will trigger the alert.
>
>Sound right?
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement