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.
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.
Displays the owner of the object, for example, the special user dbo (database owner).
Displays the type of the database object. Stored procedures are the only type used.
Displays the status of the source object on the destination server.
- The object can be moved or copied.
- Already exists
- The source objects already exist and cannot be copied.
Click to select all the objects listed in the Source field.
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.