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.

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

Login prompt before connection

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

Autoconnect at startup

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

Show system objects

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

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.

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).

Schema-organized database tree

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

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.