User Messages Editor (SQL Server)

Go Up to Microsoft SQL Server Object Editors

Note: User Messages are only on the master database.

The User Messages Editor allows you to 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. Be sure to submit your changes when done. For details, see Previewing and Submitting Object Editor Changes.

Tab	Settings and Tasks
Properties	Lets you work with the following properties:
	Message Number. Displays the message number chosen when the user message was created.
	Severity. 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.
Information	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. 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.