Choose your SQL server:
AnySQL
MySQL
MS SQL Server
PostgreSQL
Oracle
SQL Anywhere
DB2
SQLite
Firebird
MaxDB

Subscribe to our newsletter

MS SQL Maestro online Help

Prev  Return to chapter overview Next 

Setting profile options

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

 

 

Login prompt before connection

Use the option to enable MS SQL Maestro to prompt for user name and password every time you connect to the database.

 

Keep connection alive

Check the box for pinging server before each query execution.

 

 Always quote identifiers

Enables quoting all the identifiers by the backquote symbol ('`').

Uncheck the option to make SQL scripts obtained using Extract Database Wizard compatible with earlier versions of Microsoft SQL. Note that this option works only with servers that support quoting aliases.

 

Connect automatically at startup

With this option on connection to the profile database is automatically established at the application startup.

 

 Show system objects

Check the option to make system objects visible.        

 

New object's names (Don't change case, Convert to upper case, Convert to lower case)

Use the option to change the case for newly created objects.



Prev  Return to chapter overview Next