DatabaseOptions 成員
The DatabaseOptions object represents SQL Server database options.
DatabaseOptions 型別公開下列成員。
方法
.gif "受保護的方法")
.gif "公用方法")
頂端
.gif "受保護的欄位")
屬性
| 名稱 | 描述 | |
|---|---|---|
.gif "公用屬性") |
AnsiNullDefault | Gets or sets a Boolean property value that specifies whether the ANSI_NULL_DEFAULT database option is active. |
|
AnsiNullsEnabled | Gets or sets a Boolean property value that specifies whether the ANSI_NULLS_ENABLED database option is active. |
|
AnsiPaddingEnabled | Gets or sets a Boolean property value that specifies whether the ANSI_PADDING_ENABLED database option is active. |
|
AnsiWarningsEnabled | Gets or sets a Boolean property value that specifies whether the ANSI_WARNING_ENABLED database option is active. |
|
ArithmeticAbortEnabled | Gets or sets a Boolean property value that specifies whether the ARITHMETICABORT database option is active. |
|
AutoClose | Gets or sets a Boolean property value that specifies whether the AUTOCLOSE database option is active. |
|
AutoCreateStatistics | Gets or sets a Boolean property value that specifies whether the AUTOCREATESTATISTICS database option is active. |
|
AutoShrink | Gets or sets a Boolean property value that specifies whether the AUTOSHRINK database option is active. |
|
AutoUpdateStatistics | Gets or sets a Boolean property value that specifies whether the AUTOUPDATESTATISTICS database option is active. |
|
AutoUpdateStatisticsAsync | Gets or sets a Boolean property value that specifies whether the AUTOUPDATESTATISTICSASYNC database option is active. |
|
BrokerEnabled | Gets or sets a Boolean property value that specifies whether the Service Broker service is enabled. |
|
CloseCursorsOnCommitEnabled | Gets or sets a Boolean property value that specifies whether the CURSOR_CLOSE_ON_COMMIT database option is active. |
|
ConcatenateNullYieldsNull | Gets or sets a Boolean property value that specifies whether the CONCAT_NULL_YIELDS_NULL database option is active. |
|
DatabaseOwnershipChaining | Gets or sets a Boolean property value that specifies whether the database ownership chaining is active. |
|
DateCorrelationOptimization | Gets or sets a Boolean property value that specifies whether the date correlation optimization is active. |
.gif "受保護的屬性") |
ExecuteForScalar | Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (繼承自 SqlSmoObject。) |
|
IsParameterizationForced | Gets or sets a Boolean property value that specifies whether parameterization is forced on the database. |
|
IsTouched | Gets the Boolean property value that specifies whether the object properties have been updated but not yet persisted on the server. (繼承自 SqlSmoObject。) |
|
LocalCursorsDefault | Gets the Boolean value that specifies whether the local server cursors are used by default. |
|
MirroringRedoQueueMaxSize | Gets or sets the maximum size of the redo queue of the mirror server instance in KB. |
|
MirroringTimeout | Gets or sets the maximum time, in seconds, that the principal server instance waits for a PING message from another instance in the mirroring session before assuming the other instance is disconnected. |
|
NumericRoundAbortEnabled | Gets or sets a Boolean property value that specifies whether the NUMERIC_ROUNDABORT database option is active. |
|
ObjectInSpace | Gets the Boolean property value that specifies whether the object exists in isolation, or whether it is directly or indirectly connected to the instance of SQL Server. (繼承自 SqlSmoObject。) |
|
PageVerify | Specifies the type of page integrity check that Microsoft SQL Server performs when reading database pages. |
|
Parent | Gets the Database object that is the parent of the DatabaseOptions object. |
|
Properties | |
|
QuotedIdentifiersEnabled | Gets or sets a Boolean property value that specifies whether identifiers delimited by double quotation marks (" ") are Transact-SQL reserved keywords or contain characters not usually allowed by the Transact-SQL syntax rules. |
|
ReadOnly | Gets or sets the Boolean property value that specifies whether the database is read-only. |
|
RecoveryModel | Gets or sets the recovery model for the database. |
|
RecursiveTriggersEnabled | Gets or sets the Boolean value that specifies whether recursive triggers are enabled on the database. |
|
ScalarResult | Gets the scalar result for the referenced object. (繼承自 SqlSmoObject。) |
|
SnapshotIsolationState | Gets the snapshot isolation state for the database. |
|
State | Gets the state of the referenced object. (繼承自 SmoObjectBase。) |
|
Trustworthy | The TRUSTWORTHY database property is used to indicate whether the instance of SQL Server trusts the database and the contents within it. |
|
Urn | Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (繼承自 SqlSmoObject。) |
|
UserAccess | Gets or sets the database user access. |
|
UserData | Gets or sets user-defined data associated with the referenced object. (繼承自 SmoObjectBase。) |
頂端
.gif "公用事件")
明確繼承實作
| 名稱 | 描述 | |
|---|---|---|
.gif "明確介面實作") .gif "私用方法") |
IAlienObjectDiscover | (繼承自 SqlSmoObject。) |
|
IAlienObjectGetParent | (繼承自 SqlSmoObject。) |
|
IAlienObjectGetProperty | (繼承自 SqlSmoObject。) |
|
ISfcPropertyProviderGetPropertySet | (繼承自 SqlSmoObject。) |
|
IAlienObjectGetUrn | (繼承自 SqlSmoObject。) |
|
IAlienObjectResolve | (繼承自 SqlSmoObject。) |
|
IAlienObjectSetProperty | (繼承自 SqlSmoObject。) |
頂端