共用方式為


Audit.Parent 屬性

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

命名空間:  Microsoft.SqlServer.Management.Smo
組件:  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
<SfcObjectAttribute(SfcObjectRelationship.ParentObject)> _
Public Property Parent As Server 
    Get 
    Set
'用途
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)

屬性值

型別: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

請參閱

參考

Audit 類別

Microsoft.SqlServer.Management.Smo 命名空間