DatabaseOptions 類別
The DatabaseOptions object represents SQL Server database options.
繼承階層
System. . :: . .Object
Microsoft.SqlServer.Management.Smo. . :: . .SmoObjectBase
Microsoft.SqlServer.Management.Smo. . :: . .SqlSmoObject
Microsoft.SqlServer.Management.Smo..::..DatabaseOptions
命名空間： Microsoft.SqlServer.Management.Smo
組件： Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)
語法
'宣告
<SfcElementTypeAttribute("Option")> _
Public NotInheritable Class DatabaseOptions _
Inherits SqlSmoObject _
Implements IAlterable
'用途
Dim instance As DatabaseOptions
[SfcElementTypeAttribute("Option")]
public sealed class DatabaseOptions : SqlSmoObject,
IAlterable
[SfcElementTypeAttribute(L"Option")]
public ref class DatabaseOptions sealed : public SqlSmoObject,
IAlterable
[<SealedAttribute>]
[<SfcElementTypeAttribute("Option")>]
type DatabaseOptions =
class
inherit SqlSmoObject
interface IAlterable
end
public final class DatabaseOptions extends SqlSmoObject implements IAlterable
DatabaseOptions 型別公開下列成員。
屬性
| 名稱 | 說明 | |
|---|---|---|
.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 | 取得或設定 Boolean 屬性值，指定物件是否設定為執行純量選項。 (繼承自 SqlSmoObject。) |
|
IsParameterizationForced | Gets or sets a Boolean property value that specifies whether parameterization is forced on the database. |
|
IsTouched | 取得 Boolean 屬性值，指定物件屬性是否已更新但尚未保存在伺服器上。 (繼承自 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 | 取得 Boolean 屬性值，指定物件是否存在於隔離中，或是直接或間接連接至 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 | Gets a collection of Property objects that represent the 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 | 取得受參考物件的純量結果。 (繼承自 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 | 取得可唯一識別物件的統一資源名稱 (URN) 位址值。 (繼承自 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 "公用事件") |
PropertyChanged | 代表屬性變更時所發生的事件。 (繼承自 SqlSmoObject。) |
|
PropertyMetadataChanged | 代表屬性中繼資料變更時所發生的事件。 (繼承自 SqlSmoObject。) |
上層
欄位
| 名稱 | 說明 | |
|---|---|---|
.gif "受保護的欄位") |
m_ExtendedProperties | 代表屬性，此屬性定義為擴充 SqlSmoObject 所提供的屬性。 (繼承自 SqlSmoObject。) |
|
singletonParent | 代表單一父代。 (繼承自 SqlSmoObject。) |
上層
明確 繼承 實作
| 名稱 | 說明 | |
|---|---|---|
.gif "明確介面實作") .gif "私用方法") |
IAlienObject. . :: . .Discover | 探索任何相依性。不要直接在程式碼中參照此成員。其支援 SQL Server 基礎結構。 (繼承自 SqlSmoObject。) |
|
IAlienObject. . :: . .GetDomainRoot | 傳回網域的根目錄。 (繼承自 SqlSmoObject。) |
|
IAlienObject. . :: . .GetParent | 取得此物件的父系。不要直接在程式碼中參照此成員。其支援 SQL Server 基礎結構。 (繼承自 SqlSmoObject。) |
|
IAlienObject. . :: . .GetPropertyType | 取得指定的屬性類型。 (繼承自 SqlSmoObject。) |
|
IAlienObject. . :: . .GetPropertyValue | 取得指定的屬性值。 (繼承自 SqlSmoObject。) |
|
IAlienObject. . :: . .GetUrn | 取得物件的統一資源名稱。不要直接在程式碼中參照此成員。其支援 SQL Server 基礎結構。 (繼承自 SqlSmoObject。) |
|
IAlienObject. . :: . .Resolve | 取得執行個體，其中包含物件統一資源名稱之物件的相關資訊。 (繼承自 SqlSmoObject。) |
|
IAlienObject. . :: . .SetObjectState | 將物件狀態設定為指定的 SfcObjectState 值。 (繼承自 SqlSmoObject。) |
|
IAlienObject. . :: . .SetPropertyValue | 設定屬性值。 (繼承自 SqlSmoObject。) |
|
ISfcPropertyProvider. . :: . .GetPropertySet | 取得此物件屬性集的介面參考。不要直接在程式碼中參照此成員。其支援 SQL Server 基礎結構。 (繼承自 SqlSmoObject。) |
上層
備註
未來的 Microsoft SQL Server 版本將移除這項功能。請避免在新的開發工作中使用這項功能，並規劃修改目前使用這項功能的應用程式。 Configurable database options, such as ANSI settings, cursor settings, arithmetic behavior, recovery model, and the read-only status, are contained in the DatabaseOptions object. The DatabaseOptions object is a child of the Database object.
Thread Safety
此型別的任何公用靜態 (在 Microsoft Visual Basic 為共用) 成員具備多執行緒作業安全。不保證所有執行個體成員都是安全執行緒。
執行緒安全性
這個型別的任何公用 static (在 Visual Basic 中為 Shared) 成員都是執行緒安全的。並不是所有的執行個體成員都保證可以用於所有的執行緒。