Alter 方法

语法

声明
Public Sub Alter
用法
Dim instance As AffinityInfo

instance.Alter()

public void Alter()

public:
virtual void Alter() sealed

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

public final function Alter()

实现

IAlterable. . :: . .Alter() () () ()

注释

To set any AffinityInfo object properties and run the Alter method, users must have ALTER permission on the database.

示例

This example shows you how to set an Instance of SQL Server to Auto affinity.

C#

using System;
using Microsoft.SqlServer.Management.Smo;

namespace samples
{
    class Program
    {
        static void Main(string[] args)
        {
            Server dbServer = new Server("(local)");
            dbServer.AffinityInfo.Refresh();
            dbServer.AffinityInfo.AffinityType = AffinityType.Auto;
            dbServer.AffinityInfo.Alter();
        }
    }
}

Powershell

//Create the server. 
$dbServer = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")

//Set the Affinity Type to Auto
#dbServer.AffinityInfo.Refresh()
$dbServer.AffinityInfo.AffinityType = [Microsoft.SqlServer.Management.Smo.AffinityType]'Auto'
$dbServer.AffinityInfo.Alter() 

请参阅

参考