This documentation is archived and is not being maintained.

SPDatabase.DatabaseOptions Enumeration

Windows SharePoint Services 3

Specifies a Microsoft SQL Server database option that is used in a Transact-SQL statement.

This enumeration has a FlagsAttribute attribute that allows a bitwise combination of its member values.

Namespace:  Microsoft.SharePoint.Administration
Assembly:  Microsoft.SharePoint (in Microsoft.SharePoint.dll)

[FlagsAttribute]
protected enum DatabaseOptions

Member nameDescription
AutoCreateStatisticsSpecifies auto create statistics. Value = 0.
AutoUpdateStatisticsSpecifies auto update statistics. Value = 1.
AutoCloseSpecifies autoclose. Value = 2.
AutoShrinkSpecifies autoshrink. Value = 3.
AnsiNullDefaultSpecifies ANSI null default. Value = 4.
AnsiNullsSpecifies ANSI nulls. Value = 5.
AnsiWarningsSpecifies ANSI warnings. Value = 6.
ArithAbortSpecifies that a transaction is stopped and rolled back when an arithmetic error occurs. Value = 7.
ConcatNullYieldsNullSpecifies concat null yields null. Value = 8.
CursorCloseOnUpdateSpecifies cursor close on commit. Value = 9.
DboUseOnlySpecifies dbo use only. Value = 10.
DefaultToLocalCursorSpecifies default to local cursor. Value = 11.
MergePublishSpecifies merge publish. Value = 12.
NumericRoundAbortSpecifies that an error is generated and no results are returned. Value = 13.
OfflineSpecifies offline. Value = 14.
PublishedSpecifies published. Value = 15.
QuotedIdentifierSpecifies quoted identifier. Value = 16.
ReadOnlySpecifies read only. Value = 17.
RecursiveTriggersSpecifies recursive triggers. Value = 18.
SelectIntoBulkcopySpecifies select into/bulkcopy. Value = 19.
SingleUserSpecifies single user. Value = 20.
SubscribedSpecifies subscribed. Value = 21.
TornPageDetectionSpecifies torn page detection. Value = 22.
TruncLogOnChkptSpecifies trunc. log on chkpt. Value = 23.
Show: