User Messages Editor (SQL Server)

From DBArtisan
Jump to: navigation, search

Go Up to Microsoft SQL Server Object Editors

Note: User Messages are only on the master database.

The User Messages Editor lets you view or modify basic properties of a user message. It also lets you add, edit, or delete individual language versions of the message.

To edit a user message

  1. Open an editor on the user message. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks


Lets you work with the following properties:

Message Number

Displays the message number chosen when the user message was created.


Lets you modify the SQL Server error severity level (001-025).

Write to NT Event Log

Lets you specify that the message is always written to the Windows NT Event Log.


Displays the currently-defined language versions for this message number. Optionally you can:

Create a new language version for this message number. Click the Add new text for the user message button, and in the dialog box that opens, select a Language and provide the Message Text.

Select a language version of the message and click the Modify user message text button. This opens a dialog that lets you modify the Language or Message Text.

Select a language version of the message and click the Remove user message text button.

Note: You cannot create two versions of a message for the same language. NOTE: FOr a given message number there should always be a least one, us_english version of the message.

DDL View

For details on using this tab, see Viewing the SQL/DDL for an Object.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.