Transfer Master Stored Procedures Task Editor (Stored Procedures Page)

 

Applies To: SQL Server 2016

Use the Stored Procedures page of the Transfer Master Stored Procedures Task Editor dialog box to specify properties for copying one or more user-defined stored procedures from the master database in one instance of SQL Server instance to a master database in another instance of SQL Server. For more information about this task, see Transfer Master Stored Procedures Task.

System_CAPS_ICON_note.jpg Note


This task transfers only user-defined stored procedures owned by dbo from a master database on the source server to a master database on the destination server. Users must be granted the CREATE PROCEDURE permission in the master database on the destination server or be members of the sysadmin fixed server role on the destination server to create stored procedures there.

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 how the task should handle user-defined stored procedures of the same name that already exist in the master database on the destination server.

This property has the options listed in the following table:

ValueDescription
FailTaskTask fails if stored procedures of the same name already exist in the master database on the destination server.
OverwriteTask overwrites stored procedures of the same name in the master database on the destination server.
SkipTask skips stored procedures of the same name that exist in the master database on the destination server.

TransferAllStoredProcedures
Select whether all user-defined stored procedures in the master database on the source server should be copied to the destination server.

ValueDescription
TrueCopy all user-defined stored procedures in the master database.
FalseCopy only the specified stored procedures.

StoredProceduresList
Select which user-defined stored procedures in the master database on the source server should be copied to the destination master database. This option is only available when TransferAllStoredProcedures is set to False.

Integration Services Error and Message Reference
Integration Services Tasks
Transfer Master Stored Procedures Task Editor (General Page)
Expressions Page
SMO Connection Manager

Community Additions

ADD
Show: