I have following database audit specification which is now running in sql2008 R2, we do some test with the table creation and we seen it capture the log, but when we drop the table, or modify the table, this activities did not get logged.
someone where know about this and a way to fix the audit to work better ?
CREATE DATABASE AUDIT SPECIFICATION [DatabaseAuditSpecification_DBProton]
FOR SERVER AUDIT [DBProton_Database_Audit]
WITH (STATE = ON)