SQL Server properties

auto create statistics

If true, the missing statistics, required by a request for the optimization, are automatically created during the optimization.

auto update statistics

If true, the statistics not updated, required by a request for the optimization, are automatically created during the optimization.

autoclose

If true, the database is stopped correctly and its resources are freed once the last user has disconnected.

autoshrink

If true, the database files are candidates for a periodic automatic compacting.

ANSI null default

If true, CREATE TABLE the the rules SQL-92 in order to determine if a column allows NULL values.

values ANSI NULL

If true, all the comparisons with a NULL value are evaluated as unknown (UNKNOWN). If false, the comparisons of the non UNICODE values with a NULL value are valuated as TRUE if the two values are NULL.

ANSI warnings

If true, the errors or warnings are issued if the conditions such as "division by zero" are verified.

arithabort

If true, the capacity is exceeded or a division by zero has provoked the stopping of the request process or the instruction lot. If the error occurs in a transaction, this latter is cancelled (roll back). If false, a warning message is displayed, but the request process, the instruction lot or the transaction continues, as if there was no error.

concat null yields null

If true, the result is NULL if one of the two operands for the concatenation operation is NULL.

c

If true, any cursor open at the moment where a transaction is engaged or restored is closed. If false, these cursors remain open when a transaction is engaged, and the restoration of a transaction closes all cursors with the exception of those that are defined with the keyword INSENSITIVE or STATIC.

dbo use only

If true, only the owner of the database can use it.

default to local cursor

if true, the declarations of the cursor have the default value LOCAL.

publication de fusion

If true, the database can be published for a fusion replication.

numeric roundabort

If true, an error is generated when a loss of precision survives in an expression. If false, the losses of precision do not generate error messages and the result is the rounding as a function of the column or variable containing the result precision.

offline

If true, the database is off-line.

published

If true, the database can be published for the replication.

identifier between speech marks

If true, you can enclose deliminated identifiers between double speech marks.

readonly

If true, the users are only authorized to read the data in the database and not to modify it. The database cannot be in use when a new value is specified for the option read only. The master database makes exception to this rule, and only the system administrator can use it during when the option is read only.

recursive triggers

If true, it allows the recursive activation of triggers. If false, only prevents the direct reoccurrence. To deactivate the indirect reoccurrence, assign the value 0 to the server option nested triggers with the help of sp_configure.

select into /bulkcopy

If true, the instruction SELECT INTO and rapid block copies are authorized.

single user

If true, the database can only be used by one user at a time.

subscribed

If the value is true, the database can be subscribed to a publication.

torn page detection

If true, the incomplete pages can be detected.

trunc. log on chkpt

If true, a control point empties the inactive section of the journal when the database is in the mode truncation of the journal. This is the only option authorized master database.