This topic has not yet been rated - Rate this topic

Audit.Parent Property

SQL Server 2012

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)

Syntax

C++

JScript

[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.

Remarks

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

Examples

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

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

Reference

Audit Class

Microsoft.SqlServer.Management.Smo Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD