Alter Method
Collapse the table of content
Expand the table of content

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)

public void Alter()

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.

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