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)
Syntax
'Declaration
<SfcObjectAttribute(SfcObjectRelationship.ParentObject)> _
Public Property Parent As Server
Get
Set
'Usage
Dim instance As Audit
Dim value As Server
value = instance.Parent
instance.Parent = value
[SfcObjectAttribute(SfcObjectRelationship.ParentObject)]
public Server Parent { get; set; }
[SfcObjectAttribute(SfcObjectRelationship::ParentObject)]
public:
property Server^ Parent {
Server^ get ();
void set (Server^ value);
}
[<SfcObjectAttribute(SfcObjectRelationship.ParentObject)>]
member Parent : Server with get, set
function get Parent () : Server
function set Parent (value : Server)
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.
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