Online Documentation for SQL Manager for SQL server
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
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.
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.
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.