Settings プロパティ

構文

'宣言
<SfcObjectAttribute(SfcObjectRelationship.ChildObject, SfcObjectCardinality.One)> _
Public ReadOnly Property Settings As Settings
    Get
'使用
Dim instance As Server
Dim value As Settings

value = instance.Settings

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

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

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

function get Settings () : Settings

説明

Settings プロパティは Settings オブジェクトを参照しています。このオブジェクトを使用して、SQL Server のインスタンスの設定 (ログ、データ、およびバックアップ ファイル ストレージの既定の場所など) を表示または変更できます。Settings オブジェクトのプロパティには、この他にも変更可能な設定があります。

使用例

'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Display information about the instance of SQL Server in Information and Settings.
Console.WriteLine("OS Version = " & srv.Information.OSVersion)
Console.WriteLine("State = " & srv.Settings.State.ToString)
'Display information specific to the current user in UserOptions.
Console.WriteLine("Quoted Identifier support = " & srv.UserOptions.QuotedIdentifier)
'Modify server settings in Settings.

srv.Settings.LoginMode = ServerLoginMode.Integrated
'Modify settings specific to the current connection in UserOptions.
srv.UserOptions.AbortOnArithmeticErrors = True
'Run the Alter method to make the changes on the instance of SQL Server.
srv.Alter()

関連項目

参照

その他の技術情報