Run On Dialog Box
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer

Run On Dialog Box

Use this dialog box to choose a connection or reference on which to run an SQL script. To access this dialog box, right-click a script in a database project in Solution Explorer, then choose Run On from the shortcut menu.

Note   The Run On shortcut menu is only available for SQL scripts within a database project.

The dialog box lists the current database references for the project and the associated connections available in Server Explorer. Each line describes one database reference or one connection. To choose a database on which to run the script, highlight the database and click OK. Optionally, you can execute a script directly in Solution Explorer by dragging it to the database reference.

If you choose the list item called <temporary reference>, you can establish a database connection just for the duration of the script. After the script completes, this connection does not appear in the project's list of database references or in Server Explorer's list of database connections.

Add Reference
Creates a new database reference and runs the script on the new database connection. If you choose Add Reference, the Data Link Properties dialog box appears.

See Also

Adding New Data Connections in Server Explorer | Running a Script on a Database Other than the Current Default

© 2016 Microsoft