Table 2 shows the new commands that can be audited with existing event options and the new event options.
Options
login_name
object_name
Database to be in to set the option
Command being audited
encryption_key
(database-specific)
all
Database to be audited
Any
alter encryption key
create encryption key
drop encryption key
create table
drop table
alter table
sp_encryption
Example sp_audit “encryption_key”, “all”, “pubs2”, “on”
sp_audit “encryption_key”, “all”, “pubs2”, “on”
(Audits all the above commands in the pubs2 database.)
