Export (0) Print
Expand All
Expand Minimize

Transfer Error Messages Task Editor (Messages Page)

Use the Messages page of the Transfer Error Messages Task Editor dialog box to specify properties for copying one or more SQL Server user-defined error messages from one instance of SQL Server to another. For more information about this task, see Transfer Error Messages Task.

SourceConnection

Select a SMO connection manager in the list, or click <New connection...> to create a new connection to the source server.

DestinationConnection

Select a SMO connection manager in the list, or click <New connection...> to create a new connection to the destination server.

IfObjectExists

Select whether the task should overwrite existing user-defined error messages, skip existing messages, or fail if error messages of the same name already exist on the destination server.

TransferAllErrorMessages

Select whether the task should copy all or only the specified user-defined messages from the source server to the destination server.

This property has the options listed in the following table:

Value

Description

True

Copy all user-defined messages.

False

Copy only the specified user-defined messages.

ErrorMessagesList

Click the browse button (…) to select the error messages to copy.

NoteNote

You must specify the SourceConnection before you can select error messages to copy.

ErrorMessageLanguagesList

Click the browse button (…) to select the languages for which to copy user-defined error messages to the destination server. A us_english (code page 1033) version of the message must exist on the destination server before you can transfer other language versions of the message to that server.

NoteNote

You must specify the SourceConnection before you can select error messages to copy.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft