EMS logo

Produits

SQL Manager for SQL Server

Notre statut de partenariat

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for SQL Server

Documentation en ligne

Default Data Options


Default data options for newly registered databases

 

 

Environment Options - Tools - Default Data Options

 

 

CheckBox Asynchronous query execution

Check this option to allow executing queries in background mode (asynchronously).

 

CheckBox Use transactions in Data tab of object editors, SQL Editor and Query Builder

If this option is enabled, a transaction is active until the 'Data' tab is closed or the 'Commit' button is pressed; all edited records are blocked until the transaction is committed. If this option is disabled, the transaction starts and is immediately committed (autocommit) on saving each record which is blocked only for a short period of time.

 

CheckBox Use separate connections for each data view within a database

Uncheck this option to use separate connection for each data view within a database. Note that this option is only available when the Use transactions in Data tab of object editors, SQL Editor and Query Builder option is enabled.