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?