Export (0) Print
Expand All

AffinityInfo.Parent Property

This gets the parent object of the AffinityInfo object. This value is the same as the Server object that contains the AffinityInfo member.

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

[SfcObjectAttribute(SfcObjectRelationship.ParentObject)]
public Server Parent { get; }

Property Value

Type: Microsoft.SqlServer.Management.Smo.Server
The parent Server object that contains the AffinityInfo object. If a parent does not exist then null is returned.

Access to the AffinityInfo object is provided though the Server object.

This example displays the name of the Instance of SQL Server for the parent of the AffinityInfo member of the

Server object

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

namespace samples
{
    class Program
    {
        static void Main(string[] args)
        {
            Server dbServer = new Server("(local)");

            dbServer.Refresh();

            Console.WriteLine("Server Name: {0}\n" +
                              "AffinityInfo.Parent: {1}",
                dbServer.Name,
                dbServer.AffinityInfo.Parent.Name);
        }
    }
}

Powershell

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

Write-Host "Server Name:" $dbServer.Name`n AffinityInfo.Parent: 
           $dbServer.AffinityInfo.Parent.Name

Community Additions

ADD
Show:
© 2014 Microsoft