Choose your database:
MS SQL Server
SQL Anywhere

Subscribe to our news:
Jim Salmons: "That is excellent news! I will look forward to a future update with these features. It will be attention to such details that further distinguishes your excellent products from the competition.

As always, I appreciate your great products and your demonstrated customer service is equal to the high quality of your products".
Albert Rognan: "Thank you for this quick reply. I must say I am impressed of the number of functions that is available within this tool".


Add your opinion

MS SQL Maestro online Help

Prev Return to chapter overview Next

Specifying database properties

The next wizard step allows you to set common database options. All fields below are optional, i.e. it is not obligatory for you to fill them.




Compatibility Level

Sets the version of SQL Server for the database to be compatible with (60 = SQL Server 6.0,  65 = SQL Server 6.5, 70 = SQL Server 7.0,  80 = SQL Server 2000, 90 = SQL Server 2005).


Cursor Default (GLOBAL, LOCAL)

Controls whether cursor scope uses LOCAL or GLOBAL. When LOCAL is specified and a cursor is not defined as GLOBAL when created, the scope of the cursor is local to the batch, the stored procedure, or the trigger in which the cursor was created. The cursor name is valid within this scope only. When GLOBAL is specified and a cursor is not defined as LOCAL when created, the scope of the cursor is global to the connection. The cursor name can be referenced in any stored procedure or a batch executed by the connection.


Full Text Enabled

Enables full text support.


Close Cursors On Commit

If checked, all currently open cursors are closed when a transaction is committed or rolled back. Otherwise, cursors remain open when a transaction is committed; rolling back a transaction closes any cursors except those defined as INSENSITIVE or STATIC.


Read Only

Users can read data from the database but not modify it.



Controls user access to the database. If single user is specified, only one user at a time can access the database. Restricted user allows members of the db_owner fixed database role and dbcreator and sysadmin fixed server roles only to connect to the database, but does not limit their number. If multi user is selected, all users that have the appropriate permissions to connect to the database are allowed.


Torn page detection

The option allows you to enable or disable verifying the database pages to find the corrupted ones. In Microsoft SQL Server 2005 the option is called Page Verify and admits to the following values: Checksum, Torn page detection, None.


Ansi Null Default

Determines the default value, NULL or NOT NULL, of a column or user-defined data type for which the nullability is not explicitly defined in CREATE TABLE or ALTER TABLE statements. If checked, the default value is NULL.


Ansi Nulls

If checked, all comparisons to a null value evaluate to UNKNOWN. Otherwise, comparisons of non-UNICODE values to a null value evaluate to TRUE if both values are NULL.


Ansi Warnings

If checked, errors or warnings are issued when conditions such as divide-by-zero occur or null values appear in aggregate functions.


Recursive Triggers

If checked, recursive firing of AFTER triggers is allowed.


Quoted Identifiers

If checked, double quotation marks can be used to enclose delimited identifiers. Otherwise, identifiers cannot be in quotation marks and must follow all Transact-SQL rules for identifiers. Literals can be delimited by either single or double quotation marks.


Null Concat

If checked, the result of a concatenation operation is NULL when either operand is NULL.


Arithmetic Abort

If checked, a query is ended when an overflow or divide-by-zero error occurs during query execution. Otherwise, a warning message is displayed when one of these errors occurs, but the query, batch, or transaction continues to process as if no error occurred.


Auto Close

If checked, the database is shut down cleanly and its resources are set free after the last user exits.


Auto Create Statistics

If checked, any missing statistics required by a query for optimization are automatically built during query optimization. Otherwise, statistics must be manually created.


Auto Shrink

If checked, the database files are automatically shrunk during periodic checks for unused space.


Auto Update Statistics

If checked, any out-of-date statistics required by a query for optimization are automatically updated during query optimization. Otherwise, statistics must be manually updated.

Prev Return to chapter overview Next