• FYI

    I wonder if my AUDIT_DATABASE_MANAGEMENT_EVENT statement in the paragraph in below does not exist or typed incorrectly..

    so, I am going to search on internet / msdn and see what I can find out ..

    CREATE EVENT NOTIFICATION [CaptureAuditDatabaseManagementEvents]

    ON SERVER

    WITH FAN_IN

    FOR AUDIT_DATABASE_MANAGEMENT_EVENT

    TO SERVICE 'AuditDatabaseManagementEventService', 'current database';

    GO

    Cheers,
    John Esraelo