Forum Replies Created

Viewing 2 posts - 1 through 3 (of 3 total)

  • RE: SQL Server 2008 Audit_Amazing_Expecting Comments

    I am posting here as you expected through Script button in SSMS.

    SERVER LEVEL AUDIT FILE CREATION

    ================================

    USE [master]

    GO

    CREATE SERVER AUDIT [Server_audit]

    TO FILE

    ( FILEPATH = N'F:\AuditFiles\'

    ,MAXSIZE = 200 MB

    ...

  • RE: SQL Server 2008 Audit_Amazing_Expecting Comments

    Below is the result snippet about audit specification which we enabled on all databases,

    Query :

    =====

    select audit_action_id,audit_action_name,class,audited_result from sys.database_audit_specification_details

    Result :

    =====

    audit_action_idaudit_action_name classaudited_result

    DL ...

Viewing 2 posts - 1 through 3 (of 3 total)