Show TOC

Generating a User-Defined Error MessageLocate this document in the navigation structure

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

Procedure

  1. Select Start of the navigation path Tools Next navigation step Rebuild Objects Next navigation step Rebuild Triggers End of the navigation path.
  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 Start of the navigation path Database Next navigation step Generate Database End of the navigation path, select generation parameters as required (see Generating Triggers and Procedures), and click OK.