Open topic with navigation

Learn more about Toad for SQL Server at Quest.com Find solutions and downloads at the Toad for SQL Server Support Portal

General Database Options

To set general database options

1. Click | Options (ALT+T+O) and select Database | General.

2. Review the following for additional information:

   General	Description
   Number of rows to initially fetch in data tab	Enter the number of rows to initially retrieve when querying data in the Object Viewer window. If set, the query retrieves the specified number of records and then suspends the thread. When you scroll through data in the grid, additional records are retrieved on demand. Note: The number of records retrieved may be slightly lower or higher than the number you set depending on the speed of your computer. Default: 1000
   Unlimited	Return all rows for a query. Caution: If you select unlimited rows and query a large table, you may experience problems with memory usage. Default: Cleared
   Apply to editor	Apply any limitations for retrieving data in the Data tab to the editor and Query Builder. By default, the editor and Query Builder retrieve all data. Default: Cleared
   Read LOBs when initially fetching data	This option applies to the following data types:    SQL Server: TEXT, NTEXT, BINARY, VARBINARY, IMAGE   Default: Cleared
   Extended connection pool hints	Display the number of actual database connections that are associated with the current connection, how many of those connections are active, and any queries running on the connection. Default: Cleared
   Show connection category color in object explorer	If you selected a category when creating a connection to color code Editor tabs, you can select this checkbox to apply the color coding to the Object Explorer window and the navigation pane in Object Editor (Create, Alter, Drop, etc.) windows, similar to the following:
   Poll service status in connection list	Poll the service status every 60 seconds. Default: Selected
   Script Generation	Description
   Quote identifiers	Determine whether double quotes are used to delimit a character string (if selected) or are used to delimit an identifier (if cleared).    Default: Cleared
   Always preview script in object editors	Add a Show Script button, which automatically opens the SQL Script page in the object editor, so you can review the SQL script generated when creating, altering, or dropping objects before executing the script. Default: Cleared
   Auto Commit	Description
   Default for newly defined connections	Commit changes to the database when moving from one row to another in the data grid. An indicator displays in the bottom left of the application, and you can click the indicator to change the state: Notes: This option applies to new connections only. Existing connections are not affected. The Manually submit row changes as a batch option automatically overrides this setting. See Grid Options for more information.
   Commit after each statement in script with auto commit	Commit changes to the database after each statement in a script in the Editor executes if auto commit is enabled. Default: Selected

Tips:

• To navigate to the directory where option settings are stored, click the Application Data Directory link in the About dialog (Help | About).

• To search for a partial or complete option name or value, use the Search field at the bottom of each Options page. See About Options for more information.