Select Stored Procedures from the master Database (optional)

Use this screen to specify the stored procedures you want to include in the move or copy operation. This screen appears after you select User-selected stored procedures on the Select Related Objects screen.

Options

Source objects

Displays all the user-created stored procedures in the master database. Stored procedures that exist on the destination server cannot be copied; these are shown but not enabled on the list.

Owner name

Displays the owner of the object, for example, the special user dbo (database owner).

Type

Displays the type of the database object. Stored procedures are the only type used.

Destination

Displays the status of the source object on the destination server.

OK

The object can be moved or copied.

Already exists

The source objects already exist and cannot be copied.

Select All

Click to select all the objects listed in the Source field.

Clear All

Click to clear all the selected objects in the Source field.

Stored Procedures Copy Option

All stored procedures detected at package runtime

Use this option to copy all stored procedures detected at package runtime.

Selected stored procedures

Use this option to copy all the stored procedures.