Export (0) Print
Expand All

Audit.Parent Property

Gets the Server object that is the parent of the Audit object.

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

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

Property Value

Type: Microsoft.SqlServer.Management.Smo.Server
A Server object that is the parent of the Audit object.

The parent of the Audit object is the instance of SQL Server on which the audit is defined.

The following code example demonstrates how to get the name of the parent server and display it on the console.

C#

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

namespace samples
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create the audit
            Server dbServer = new Server("(local)");
            Audit dbAudit = new Audit(dbServer, "Test Audit");
            dbAudit.DestinationType = AuditDestinationType.File;
            dbAudit.FilePath = "C:\\AuditDirectory";
            dbAudit.Create();
             
            //Display the name of the parent server on the console
            Console.WriteLine(dbAudit.Parent.Name);
        }
    }
}

Powershell

#Create the audit 
$dbServer = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$dbAudit = New-Object Microsoft.SqlServer.Management.Smo.Audit($dbServer, "Test Audit")
$dbAudit.DestinationType = [Microsoft.SqlServer.Management.Smo.AuditDestinationType]'File'
$dbAudit.FilePath = "C:\AuditDirectory"
$dbAudit.Create()

#Display the name of the parent server on the console
Write-Host $dbAudit.Parent.Name
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft