Copy Database Wizard (Select Database Objects)
Use this page to select the objects to include in the move or copy operation. To include an item in the move or copy operation, click the object name in the Available related objects box, and then click the >> button to move the object to the Selected related objects box. To exclude an item in the move or copy operation, click the object name in the Selected related objects box, and then click the << button to move the object to the Available related objects box.
By default all objects of each selected type are transferred. To choose individual objects of any type, click the ellipsis button next to any object type in the Selected related objects box. This opens a dialog box where you can select individual objects.
Note
This page is only available when the source and destination are different servers.
Options
Logins (All logins at run time)
Include logins in the move or copy operation. Selected by default.Stored procedures from master database
Include stored procedures from the master database in the move or copy operation.Note
Extended stored procedures and their associated DLLs are not eligible for automated copy in SQL Server 2005.
SQL Server Agent jobs
Include jobs from the msdb database in the move or copy operation.User-defined error messages
Include user-defined error messages in the move or copy operation.Endpoints
Include endpoints defined in the source database. SQL Server 2005 only.Full-text catalog
Include full-text catalogs from the source database. SQL Server 2005 only.SSIS Package
Include SSIS packages defined in the source database. SQL Server 2005 only.Description
A description of the object.