Online Documentation for SQL Manager for SQL server

Advanced


CheckBox Allow snapshot transaction isolation level (ALLOW_SNAPSHOT_ISOLATION)

If this option is enabled, SQL Server will execute snapshot transactions against the specified database when transactions are explicitly set to the SNAPSHOT transaction isolation level.

 

CheckBox Row versioning in Read Comitted level (READ_COMMITTED_SNAPSHOT)

If this option is enabled, transactions setting the read-committed isolation level use row versioning instead of locking.

 

CheckBox Additional log information for third party products (SUPPLEMENTAL_LOGGING)

When this option is enabled, additional information is added to the log for third-party products. Setting this option on will increase log space usage and may impact performance.

 

CheckBox Date correlation statistics in linked tables (DATE_CORRELATION_OPTIMIZATION)

If this option is enabled, SQL Server maintains correlation statistics between any two tables in the database that have DATETIME columns and are linked by a one-column foreign key constraint.

 

Database Properties - Options - Advanced

 

 

Service Broker options

RadioButton ENABLE_BROKER

Specifies that Service Broker is enabled for the specified database. The IS_BROKER_ENABLED flag is set to TRUE in the sys.databases catalog view and message delivery is started.

RadioButton DISABLE_BROKER

Specifies that Service Broker is disabled for the specified database. The IS_BROKER_ENABLED flag is set to FALSE in the sys.databases catalog view and message delivery is stopped.

RadioButton NEW_BROKER

Specifies that the database should receive a new broker identifier. Because the database is considered to be a completely new service broker, all existing conversations in the database are immediately removed without producing end dialog messages.

RadioButton ERROR_BROKER_CONVERSATIONS

Specifies that conversations in the database should receive an error message when the database is attached. This allows your applications to perform normal clean up for existing conversations.

 

Parametrization

RadioButton Simple Parametrization (SIMPLE)

Queries are parameterized on the basis of the default behavior of the database.

RadioButton Forced Parametrization (FORCED)

SQL Server parameterizes all queries in the database.

 

Containment

Contained Database is independent of the SQL Server Instance. All the database metadata and user information is stored inside the database itself.

RadioButton None

Check this option to make a non-contained database.

RadioButton Partial

Check this option to make a database partially contained. A partially contained database is a contained database that can allow some features that cross the database boundary (The boundary between a database and the instance of SQL Server or between a database and other databases). SQL Server includes the ability to determine when the containment boundary is crossed. The partially contained database can store important information in the database so the database still has the information after it is moved.