TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

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:
© 2016 Microsoft