Server::Settings Property

 

Gets modifiable settings for the instance of SQL Server.

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

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

Property Value

Type: Microsoft.SqlServer.Management.Smo::Settings^

A Settings object that specifies modifiable settings for the instance of SQL Server.

The Settings property points to the Settings object. This can be used to view or modify settings for the instance of SQL Server, such as the default location of the log, the data, and the backup file storage. The Settings object properties contain other settings that you can modify.

Visual Basic

PowerShell

$srv = new-object Microsoft.SqlServer.Management.Smo.Server("(local)")
Write-Host "OS Version =" $srv.Information.OSVersion
Write-Host "State =" $srv.Settings.State.ToString()
Write-Host "Quoted Identifier support =" $srv.UserOptions.QuotedIdentifier
$srv.Settings.LoginMode = [Microsoft.SqlServer.Management.Smo.ServerLoginMode]::Integrated
$srv.UserOptions.AbortOnArithmeticErrors = $TRUE
$srv.Alter()
Return to top
Show: