Audit.Disable 메서드

Disables the audit.

네임스페이스:  Microsoft.SqlServer.Management.Smo
어셈블리:  Microsoft.SqlServer.Smo(Microsoft.SqlServer.Smo.dll)

구문

‘선언
Public Sub Disable
‘사용 방법
Dim instance As Audit

instance.Disable()
public void Disable()
public:
void Disable()
member Disable : unit -> unit
public function Disable()

주의

The Disable method disables the audit, if it has already been enabled. If the audit has not been previously enabled using the Enable method, nothing will happen when Disable is called.

The following code example demonstrates how to disable an 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();

           //Enable the audit
            dbAudit.Enable();
            Console.WriteLine("The audit is enabled")

            //Disable the audit
            dbAudit.Disable();
            if (dbAudit.Enabled == false)
            { 
            Console.WriteLine("The audit has been disabled");
            }
        }
    }
}

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

#Enable the audit
$dbAudit.Enable()
Write-Host "The audit is enabled"

#Disable the audit
$dbAudit.Disable()
If ($dbAudit.Enabled -eq $FALSE)
{
   Write-Host "The audit has been disabled"
}

참고 항목

참조

Audit 클래스

Microsoft.SqlServer.Management.Smo 네임스페이스