SPDatabase.DatabaseOptions Enumeration

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)
Available in Sandboxed Solutions: No


<FlagsAttribute> _
Protected Enumeration DatabaseOptions
Dim instance As SPDatabase.DatabaseOptions
protected enum DatabaseOptions


Member name Description
AutoCreateStatistics Specifies auto create statistics. Value = 0.
AutoUpdateStatistics Specifies auto update statistics. Value = 1.
AutoClose Specifies autoclose. Value = 2.
AutoShrink Specifies autoshrink. Value = 3.
AnsiNullDefault Specifies ANSI null default. Value = 4.
AnsiNulls Specifies ANSI nulls. Value = 5.
AnsiWarnings Specifies ANSI warnings. Value = 6.
ArithAbort Specifies that a transaction is stopped and rolled back when an arithmetic error occurs. Value = 7.
ConcatNullYieldsNull Specifies concat null yields null. Value = 8.
CursorCloseOnUpdate Specifies cursor close on commit. Value = 9.
DboUseOnly Specifies dbo use only. Value = 10.
DefaultToLocalCursor Specifies default to local cursor. Value = 11.
MergePublish Specifies merge publish. Value = 12.
NumericRoundAbort Specifies that an error is generated and no results are returned. Value = 13.
Offline Specifies offline. Value = 14.
Published Specifies published. Value = 15.
QuotedIdentifier Specifies quoted identifier. Value = 16.
ReadOnly Specifies read only. Value = 17.
RecursiveTriggers Specifies recursive triggers. Value = 18.
SelectIntoBulkcopy Specifies select into/bulkcopy. Value = 19.
SingleUser Specifies single user. Value = 20.
Subscribed Specifies subscribed. Value = 21.
TornPageDetection Specifies torn page detection. Value = 22.
TruncLogOnChkpt Specifies trunc. log on chkpt. Value = 23.

See Also


Microsoft.SharePoint.Administration Namespace