Audit.Drop 方法

Removes the audit from the instance of SQL Server.

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

語法

'宣告
Public Sub Drop
'用途
Dim instance As Audit

instance.Drop()

public void Drop()

public:
virtual void Drop() sealed

abstract Drop : unit -> unit  
override Drop : unit -> unit

public final function Drop()

實作

IDroppable.Drop()

備註

The audit is removed with the FORCE_DROP option. The audit must be disabled by the Disable method before it can be dropped.

範例

The following code example demonstrates how to drop a disabled audit.

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();

            //Drop the audit
            dbAudit.Drop();
        }
    }
}

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()

#Drop the audit
$dbAudit.Drop()

請參閱

參考

Audit 類別

Microsoft.SqlServer.Management.Smo 命名空間