Select Objects

DTS Designer

DTS Designer Help

Select Objects

Use this dialog box to select the objects that you want to transfer to the new database.

Note  Selecting a check box does not automatically mark the corresponding object to be transferred. The objects to appear are in the Objects list, from which you then select the objects to transfer.

Options

Show all tables

Display all tables in the database in the Objects table.

Show all views

Display all views in the database in the Objects table.

Show all stored procedures

Display all stored procedures in the database in the Objects table.

Show all defaults

Display all defaults in the database in the Objects table.

Show all rules

Display all rules in the database in the Objects table.

Show user-defined data types

Display all user-defined data types in the database in the Objects table.

Select All

Select all objects in the database as eligible for transfer to the new database.

Check

Place a check mark next to all selected objects.

Uncheck

Remove the check mark from all selected objects.

See Also

Copy SQL Server Objects Task