Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Select Objects

SQL Server 2000

Select Objects

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

Note  If you select one of the options below, you do not mark automatically the objects to be transferred. Instead, you cause the objects to appear in the Objects table. From that table, you then select the objects to transfer.

Options

Show all tables

View 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 user-defined functions

Display all user-defined functions in the Objects table.

Show all defaults

Display all database defaults in the Objects table.

Show all rules

Display all database rules in the Objects table.

Show user-defined data types

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

Objects table

Select items individually to include them in the transfer or click the following:

Select All
Select all objects in the database as eligible for transfer to the new database.
Check
Select one or more database objects.
Uncheck
Remove one or more database objects from selection.

See Also

Copy SQL Server Objects Task

Show:
© 2015 Microsoft