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

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

Enjoy your day !!