General, Database Tools, Options Dialog Box
Use this page of the Options dialog box to change the default settings for database tools. You can access the Options dialog box from the Tools menu.
Note
Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. The Visual Studio edition that you have and the settings that you use determine these elements. For more information, see Visual Studio Settings.
Query, View, and Table Designers
Warn when changing schema
Select this option to show a dialog asking if you are certain you want to change the schema (collection of database entities that form a single namespace) of the database object.Issue the SET statements that ensure commits succeed
Select this option to include special SET statements in any SQL script transmitted to a SQL Server database whenever you save a table or database diagram. The SET statements establish per-session settings that can affect the database objects created by the script. For example, if you check this option and connect to a SQL Server 2000 database, your updates to the database might include statements to control the QUOTED_IDENTIFIER, ANSI_PADDING, and ANSI_NULLS settings for the tables the script is creating.
Script and Stored Procedure, and Function Editors
- Enable DML markers
Setting this option enables the SQL pane to draw blue outlines around recognized blocks of Data Manipulation Language (DML). When you enable DML markers, you can easily select and edit the blocks of SQL text in Query and View Designer in addition to editing them in the SQL pane. For more information, see Using Query Designer with Stored Procedures and User-Defined Functions and Opening Stored Procedures and User-Defined Functions.
Script/Query Execution
- Warn when executing a script or query by dropping it on a reference
Dragging a script file or query file to a database reference executes the script or query on the referenced database. Setting this option displays the Execute Scripts or Queries dialog box where you can proceed with the action by clicking Yes or cancel the action by clicking No.
See Also
Reference
Query/View Designer, Database Tools, Options Dialog Box
Table and Diagram Options, Table and Database Designers, Database Tools, Options Dialog Box
Column Options, Table and Database Designers, Database Tools, Options Dialog Box