Generating a User-Defined Error Message

You can choose to generate a user-defined error message from the trigger generation parameters box.

1. Select Tools > Rebuild Objects > Rebuild Triggers.
2. Click the Error Messages tab, and select the User-defined radio button.
3. Enter the name of the table that contains the error message, the name of the column that contains the error number, and the name of the column that contains the error message text.
   
   
   
4. Click the General tab and select the mode and triggers to create.
5. Click the Selection tab and select the tables for which you want to create triggers.

   For more information on rebuilding triggers, see Rebuilding Triggers.

6. Click OK.

   The trigger rebuilding process is shown in the Output window.

7. Select Database > Generate Database, select generation parameters as required (see Generating Triggers and Procedures), and click OK.