다음을 통해 공유

  • 아티클

DatabaseOptions 속성

데이터베이스의 구성 옵션을 포함하는 DatabaseOptions 개체를 가져옵니다.

네임스페이스:  Microsoft.SqlServer.Management.Smo
어셈블리:  Microsoft.SqlServer.Smo(Microsoft.SqlServer.Smo.dll)

구문

‘선언
<SfcObjectAttribute(SfcObjectRelationship.ChildObject, SfcObjectCardinality.One)> _
Public ReadOnly Property DatabaseOptions As DatabaseOptions
    Get
‘사용 방법
Dim instance As Database
Dim value As DatabaseOptions

value = instance.DatabaseOptions

[SfcObjectAttribute(SfcObjectRelationship.ChildObject, SfcObjectCardinality.One)]
public DatabaseOptions DatabaseOptions { get; }

[SfcObjectAttribute(SfcObjectRelationship::ChildObject, SfcObjectCardinality::One)]
public:
property DatabaseOptions^ DatabaseOptions {
    DatabaseOptions^ get ();
}

[<SfcObjectAttribute(SfcObjectRelationship.ChildObject, SfcObjectCardinality.One)>]
member DatabaseOptions : DatabaseOptions

function get DatabaseOptions () : DatabaseOptions

속성 값

유형: Microsoft.SqlServer.Management.Smo. . :: . .DatabaseOptions
데이터베이스 구성 옵션을 포함하는 DatabaseOptions 개체 값입니다.

주의

The DatabaseOptions property points to a DatabaseOptions object. The DatabaseOptionsobject contains a set of Boolean properties that control the database options, such as the ANSI, statistics, and mirroring settings.

예

VB

'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server

'Reference the AdventureWorks2008R2 database.
Dim db As Database
db = srv.Databases("AdventureWorks2008R2")

'Force parameterization on the database by setting database options.
db.DatabaseOptions.IsParameterizationForced = True

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2008R2")

$db.DatabaseOptions.IsParameterizationForced = $TRUE