Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Select Related Objects

SQL Server 2000

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.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.