Online Documentation for SQL Manager for SQL server

Options


The Options section of the Database Registration Info dialog allows you to set various options for the database.

 

Database Registration Info - Setting common database options

 

 

Customize common database options according to your needs. The detailed description is given below.

 

CheckBox Login prompt before connection

Enables SQL Manager for SQL Server to prompt for user name and password each time you connect to the database.

 

CheckBox Autoconnect at startup

Check this option to specify that SQL Manager for SQL Server automatically establishes connection to the registered database at application startup.

 

CheckBox Show system objects

This option determines whether SQL Server system objects are displayed in the DB Explorer tree.

 

CheckBox Refresh objects on connection

This option allows you to enable/disable refreshing objects on connection to the database. It is highly recommended to uncheck this option if your database contains many objects or if connection to the database is slow.

 

CheckBox Always use client cursor to get data

This option sets cursor to client. This might be useful for remote server connections, e.g. upon connection via Internet.

 

CheckBox Don't use this database registration info to get server objects

If this option is enabled, the registration info of this database will not be used to establish server connection and get server objects (when expanding the Server Objects node in DB Explorer).

 

CheckBox Schema-organized database tree

If this option is disabled, the object tree is built without grouping into schemas (for SQL Server 2005 and higher).

 

CheckBox Ping server every ... seconds

If this option is ON, the program sends 'SELECT 1' statement every period specified to keep active connection to the server.