Configuration プロパティ
SQL Server のインスタンスの構成オプションを取得します。
名前空間: Microsoft.SqlServer.Management.Smo
アセンブリ: Microsoft.SqlServer.Smo (Microsoft.SqlServer.Smo.dll)
構文
'宣言
<SfcObjectAttribute(SfcObjectRelationship.ChildObject, SfcObjectCardinality.One)> _
Public ReadOnly Property Configuration As Configuration
Get
'使用
Dim instance As Server
Dim value As Configuration
value = instance.Configuration
[SfcObjectAttribute(SfcObjectRelationship.ChildObject, SfcObjectCardinality.One)]
public Configuration Configuration { get; }
[SfcObjectAttribute(SfcObjectRelationship::ChildObject, SfcObjectCardinality::One)]
public:
property Configuration^ Configuration {
Configuration^ get ();
}
[<SfcObjectAttribute(SfcObjectRelationship.ChildObject, SfcObjectCardinality.One)>]
member Configuration : Configuration
function get Configuration () : Configuration
プロパティ値
型: Microsoft.SqlServer.Management.Smo. . :: . .Configuration
SQL Server のインスタンスの構成オプションを示す Configuration オブジェクトです。
説明
Configuration プロパティは構成オブジェクトを参照しています。このオブジェクトは、FillFactor や NestedTriggers などの構成可能な各サーバー設定のプロパティを保持します。各プロパティは、サーバー設定の最大値、最小値、および実行値を含んでいる ConfigProperty オブジェクトを参照しています。サーバー設定が詳細設定であるかどうかと、動的設定であるかどうかも確認できます。サーバー設定を変更するには、ConfigProperty オブジェクトのプロパティを設定します。サーバー設定が動的でない場合、システムを再起動する必要もあります。
使用例
Visual Basic
'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Display all the configuration options.
Dim p As ConfigProperty
For Each p In srv.Configuration.Properties
Console.WriteLine(p.DisplayName)
Next
Console.WriteLine("There are " & srv.Configuration.Properties.Count.ToString & " configuration options.")
'Display the maximum and minimum values for ShowAdvancedOptions.
Dim min As Integer
Dim max As Integer
min = srv.Configuration.ShowAdvancedOptions.Minimum
max = srv.Configuration.ShowAdvancedOptions.Maximum
Console.WriteLine("Minimum and Maximum values are " & min & " and " & max & ".")
'Modify the value of ShowAdvancedOptions and run the Alter method.
srv.Configuration.ShowAdvancedOptions.ConfigValue = 0
srv.Configuration.Alter()
'Display when the change takes place according to the IsDynamic property.
If srv.Configuration.ShowAdvancedOptions.IsDynamic = True Then
Console.WriteLine("Configuration option has been updated.")
Else
Console.WriteLine("Configuration option will be updated when SQL Server is restarted.")
End If
PowerShell
$srv = new-object Microsoft.SqlServer.Management.Smo.Server("(local)")
#Display all the configuration options
Foreach ($p in $srv.Configuration.Properties)
{
Write-Host $p.DisplayName
}
Write-Host "There are" $srv.Configuration.Properties.Count "configuration options."
$min = $srv.Configuration.ShowAdvancedOptions.Minimum
$max = $srv.Configuration.ShowAdvancedOptions.Maximum
Write-Host "Minimum and Maximum values are" $min "and" $max"."
$srv.Configuration.ShowAdvancedOptions.ConfigValue = 0
$srv.Configuration.Alter()
if ($srv.Configuration.ShowAdvancedOptions.IsDynamic -eq $TRUE)
{
Write-Host "Configuration option has been updated."
}
else
{
Write-Host "Configuration option will be updated when SQL Server is restarted."
}