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

Set Default Reference Dialog Box

Use this dialog box to indicate which database will be used when you run scripts or queries within a project. To access this dialog box, right-click the database project node in Solution Explorer, then choose Set Default Reference on the shortcut menu.

Note   The Set Default Reference shortcut menu is only available for a database project.

The Set Default Reference dialog box lists the current references for the project and all of the other database connections available in Server Explorer. Each line describes one database reference or one connection. To establish an existing connection or reference as the default, select the appropriate list item and click OK.

When you set the default database reference, several important things happen: the selected default database reference is added to the Database References folder (if not previously added); the icon is changed to designate the default database reference; and the defaults for other commands are changed. For example, if you create a new query, you are automatically prompted to add tables from the default database.

Add Reference
Displays the Data Link Properties dialog box for defining a new connection.

See Also

Setting a Default Database Reference for a Database Project | Adding a Database Reference to a Database Project | Running a Script on a Database Other than the Current Default

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
© 2014 Microsoft. All rights reserved.