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 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
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. 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.