Page History

...

1. Right-click on the instance you want to audit and select Properties. 
2. In the Registered SQL Server Properties window, select the Audited Activities tab. 
3. Under the Audited Activity options, select the Capture DML and SELECT activities using SQL Server Audit Specifications checkbox.
4. Click OK. 

Enable Audit Logs mode using the Web Console

Users wanting to take advantage of SQL Server Audit Logs auditing capabilities can do so by completing the following steps:

In the Registered SQL Server Properties window, select the Audited Activities tab. 

Under the Audited Activity options, select the Capture DML and SELECT activities using SQL Server Audit Specifications checkbox.

Click OK.