• Article

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.

Options

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

    Note

    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.

    Note

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