Server.Settings Server.Settings Server.Settings Property

Definition

Gets modifiable settings for the instance of SQL Server.

public:
 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.

Examples

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()  

Remarks

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