General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
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?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only