Database Projects, Database Tools, Options Dialog Box

Use this page of the Options dialog box to change the default settings for database projects. You can access the Options dialog box from the Tools menu.

Query and Schema

• 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 Editors

• Enable DML markers
  Setting this option enables the SQL Editor 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 the Query Designer in addition to editing them in the SQL Editor. For more information, see Using Query Designer with Stored Procedures and User-Defined Functions and Opening Stored Procedures and User-Defined Functions.

Script Execution

• Warn when executing a script by dropping it on a reference
  Dragging a script file to a reference executes the script file on the referenced database. Setting this option displays the Execute Scripts dialog box where you can proceed with the script by clicking Yes or avoid executing the script by clicking No.

See Also

Database Designer, Database Tools, Options Dialog Box | Query/View Designer, Database Tools, Options Dialog Box | Server Explorer, Database Tools, Options Dialog Box | Database Projects