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)
Syntax
<FlagsAttribute> _
Protected Enumeration DatabaseOptions
Dim instance As SPDatabase.DatabaseOptions
[FlagsAttribute]
protected enum DatabaseOptions
Members
| 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. |