Server.Settings Server.Settings Server.Settings Property


Gets modifiable settings for the instance of SQL Server.

 property Microsoft::SqlServer::Management::Smo::Settings ^ Settings { Microsoft::SqlServer::Management::Smo::Settings ^ get(); };
[Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcObject(Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcObjectRelationship.ChildObject, Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcObjectCardinality.One)]
public Microsoft.SqlServer.Management.Smo.Settings Settings { get; }
Public ReadOnly Property Settings As Settings
Property Value

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


Visual Basic


$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  


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.

Applies to

See Also