Export (0) Print Expand All This topic has not yet been rated -
Rate this topic  Creating a User-Defined Event  You can create
user-defined events if you want to monitor events other than
events that are predefined by SQL Server. You can also assign a
severity level to each user-defined event.  When using SQL
Server Management Studio, select the Write to Windows
application event log option for each user-defined event
message, to ensure that the messages are logged. By default,
user-defined messages of severity lower than 19 are not sent to
the Microsoft Windows application log when they occur. User-
defined messages of severity lower than 19 therefore do not
trigger SQL Server Agent alerts.  User-defined events must have
a unique message number. Message numbers for a user-defined
event must be greater than 50,000. You can define messages for
the event in multiple languages. However, an En-US error message
must exist before messages in other languages can be added.  If
you administer a multiple-language SQL Se