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.
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.
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.
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.
Service Broker options
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.
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.
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.
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.
Simple Parametrization (SIMPLE)
Queries are parameterized on the basis of the default behavior of the database.
Forced Parametrization (FORCED)
SQL Server parameterizes all queries in the database.
Contained Database is independent of the SQL Server Instance. All the database metadata and user information is stored inside the database itself.
Check this option to make a non-contained database.
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.