Compartilhar via


Método Server.Alter

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

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

Sintaxe

'Declaração
Public Sub Alter
'Uso
Dim instance As Server

instance.Alter()
public void Alter()
public:
virtual void Alter() sealed
abstract Alter : unit -> unit  
override Alter : unit -> unit
public final function Alter()

Implementa

IAlterable.Alter()

Comentários

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.

Exemplos

'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Display information about the instance of SQL Server in Information and Settings.
Console.WriteLine("OS Version = " & srv.Information.OSVersion)
Console.WriteLine("State = " & srv.Settings.State.ToString)
'Display information specific to the current user in UserOptions.
Console.WriteLine("Quoted Identifier support = " & srv.UserOptions.QuotedIdentifier)
'Modify server settings in Settings.

srv.Settings.LoginMode = ServerLoginMode.Integrated
'Modify settings specific to the current connection in UserOptions.
srv.UserOptions.AbortOnArithmeticErrors = True
'Run the Alter method to make the changes on the instance of SQL Server.
srv.Alter()

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

Consulte também

Referência

Server Classe

Sobrecarregado Alter

Namespace Microsoft.SqlServer.Management.Smo

Outros recursos

Definindo propriedades

Chamando métodos

Gerenciando servidores