Hello People, What level audit for capture operations DML?
for example, this picture:
http://img165.imageshack.us/my.php?image=auditoriapv4.jpg
i'm need make put SSMS and not via t-sql...
in T-SQL, this code:
....
CREATE DATABASE AUDIT SPECIFICATION [Auditoria_DML]
FOR SERVER AUDIT MinhaAuditoria_File
ADD (SELECT, INSERT, UPDATE, DELETE
ON HumanResources.EmployeePayHistory
BY PUBLIC),
ADD (SELECT, INSERT, UPDATE, DELETE
ON Sales.CreditCard
BY PUBLIC)
WITH (STATE = ON)
GO
but, using SSMS i'm do know...