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
- Open an editor on the user message. For details, see Opening an Object Editor.
- 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. | |||
| |||
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.