Export (0) Print
Expand All
Expand Minimize

Transfer Master Stored Procedures Task Editor (Stored Procedures Page)

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.

NoteNote

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:

Value

Description

FailTask

Task fails if stored procedures of the same name already exist in the master database on the destination server.

Overwrite

Task overwrites stored procedures of the same name in the master database on the destination server.

Skip

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

Value

Description

True

Copy all user-defined stored procedures in the master database.

False

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

Community Additions

ADD
Show:
© 2014 Microsoft