Field help (APROPOPT)
Database options.
Here is a list of options that can be found :
Option | Description |
|---|---|
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. |