Transfer Error Messages Task, before discussing this task, we should know basic knowledge about Error Messages in SQL Server Management Studio.
Error Messages are used in SQL Server for different purposes for letting users know what kind of issue caused to stop the process. There are attributes for every Error Message . Please refer to this link if you want to know more about Error Messages in SSMS.
Transfer Error Messages Task allows us to transfer the custom created or user error messages from one server to another server.
Source and Destination connection are the fields used to connect to servers.
IfObjectExists: FailTask lets us to fail the task if the object already exists, Overwrite the existing or Skip this task if the error already exists.
TransferAllErrorMessages : We can transfer all the custom defined error messages if you wish to. If not we will need to select ErrorMessagesList for selecting required Error Messages to be transferred from the collection.
ErrorMessageLanguageList: For every error a language ID is associated with it. This states what type of language is used for the error message. We can select all messages under a particaular language using language ID.
Error Messages are used in SQL Server for different purposes for letting users know what kind of issue caused to stop the process. There are attributes for every Error Message . Please refer to this link if you want to know more about Error Messages in SSMS.
Transfer Error Messages Task allows us to transfer the custom created or user error messages from one server to another server.
IfObjectExists: FailTask lets us to fail the task if the object already exists, Overwrite the existing or Skip this task if the error already exists.
TransferAllErrorMessages : We can transfer all the custom defined error messages if you wish to. If not we will need to select ErrorMessagesList for selecting required Error Messages to be transferred from the collection.
ErrorMessageLanguageList: For every error a language ID is associated with it. This states what type of language is used for the error message. We can select all messages under a particaular language using language ID.
No comments:
Post a Comment