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 类型公开以下成员。
属性
名称 | 说明 | |
---|---|---|
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. | |
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 继承。) |
页首
方法
页首
事件
名称 | 说明 | |
---|---|---|
PropertyChanged | 表示更改属性时发生的事件。 (从 SqlSmoObject 继承。) | |
PropertyMetadataChanged | 表示属性元数据更改时发生的事件。 (从 SqlSmoObject 继承。) |
页首
字段
名称 | 说明 | |
---|---|---|
m_ExtendedProperties | 表示一个属性,可以对该属性进行定义以便扩展 SqlSmoObject 提供的属性。 (从 SqlSmoObject 继承。) | |
singletonParent | 表示单一父级。 (从 SqlSmoObject 继承。) |
页首
显式接口实现
名称 | 说明 | |
---|---|---|
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 中的 Shared)成员在多线程操作中是安全的。不保证所有实例成员都是线程安全的。
线程安全
此类型的任何公共 static(在 Visual Basic 中为 Shared) 成员都是线程安全的。不保证所有实例成员都是线程安全的。