Select Related Objects

Use this screen to modify which objects are to be included in the move or copy operation.

Options

Logins (recommended)

Include logins in the move or copy operation; selected by default.

All logins detected at package runtime

Select to copy all logins from the source serve. The list of logins copied is determined at run time.

Only logins used by the selected database (optional)

Select to copy only the logins used by the selected databases.

Shared stored procedures from the master database (optional)

Include stored procedures from the master database in the move or copy operation; selected by default.

Note  Extended stored procedures and their associated DLLs are not eligible for automated copy in Microsoft® SQL Server™ 2000.

All stored procedures detected at package runtime

Select to copy all dbo (database owner) stored procedures in the master database (except those with name conflicts).

User-selected stored procedures

Select to enable the Select Stored Procedures from master Database screen, which provides a detailed selection of stored procedures in the master database.

Jobs from msdb (optional)

Include jobs from the msdb database in the move or copy operation; selected by default.

All jobs detected at package runtime

Select to copy all jobs in the msdb database (except those with name conflicts or associated with Replication).

User-selected jobs

Select to enable the Select Object from msdb screen, which provides a detailed selection of jobs in the msdb database.

User-defined error messages (optional)

Include user-defined error messages in the move or copy operation; selected by default.

All error messages detected at package runtime

Select to move or copy all messages (except those with ID conflicts).

User-selected error messages (optional)

Select to enable the Select User-Defined Error Messages screen, which provides a detailed selection of error messages.