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