Server.Alter Method ()


Updates any Server object property changes on the instance of SQL Server. 

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

abstract Alter : unit -> unit
override Alter : unit -> unit

The Alter method updates any changes that have been made to the Server object's properties since the Server object was created or since the last Alter statement. The modifications are combined and sent to the instance of SQL Server in one network trip.


$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
Return to top