SQL server auditing action type

Copper Contributor

dear all , any one face that the list in : Server Audit Specification properties > audit action type does not include : select , insert , delete ...etc .

i try to audit the insert only for a database in my server ( not all ) but i cant .




3 Replies

@salamehmah  You will get it under Database Audit Specification not in Server Audit Specification.

Database -> Security -> Database Audit Specification


Database Audit Specification.jpg

yes that's it , ifound it there , thanks a lot

Enjoy your day !!