UserOptions.Alter UserOptions.Alter UserOptions.Alter Method

Definition

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

Overloads

Alter() Alter() Alter()

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

Alter(Boolean) Alter(Boolean) Alter(Boolean)

Updates any UserOptions object property changes on the instance of Microsoft SQL Server with the option to override value checking.

Alter() Alter() Alter()

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

public:
 virtual void Alter();
public void Alter ();
Public Sub Alter ()

Examples

Configuring SQL Server in SMO

Remarks

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

See Also

Alter(Boolean) Alter(Boolean) Alter(Boolean)

Updates any UserOptions object property changes on the instance of Microsoft SQL Server with the option to override value checking.

public:
 void Alter(bool overrideValueChecking);
public void Alter (bool overrideValueChecking);
Public Sub Alter (overrideValueChecking As Boolean)
Parameters
overrideValueChecking
Boolean Boolean Boolean

A Boolean value that specifies whether to override checking user option values.

If True, value checking is overridden.

If False, value checking is performed.

Examples

Configuring SQL Server in SMO

Remarks

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

Applies to