E facut cu SSMS dar arata asa
USE [master]
GO


CREATE SERVER AUDIT [My_Security_Audit]
TO FILE
(    FILEPATH = N'D:\Audit\'
    ,MAXSIZE = 0 MB
    ,MAX_ROLLOVER_FILES = 2147483647
    ,RESERVE_DISK_SPACE = OFF
)
WITH
(    QUEUE_DELAY = 1000
    ,ON_FAILURE = CONTINUE
    ,AUDIT_GUID = 'f43a9ca2-c7db-421c-9b25-fc178b39aa8f'
)
GO


USE [Database]
GO

CREATE DATABASE AUDIT SPECIFICATION [Audit_Date]
FOR SERVER AUDIT [My_Security_Audit]
ADD (DELETE ON SCHEMA::[dbo] BY [userul]),
ADD (EXECUTE ON SCHEMA::[dbo] BY [userul]),
ADD (INSERT ON SCHEMA::[dbo] BY [userul]),
ADD (SELECT ON SCHEMA::[dbo] BY [userul]),
ADD (UPDATE ON SCHEMA::[dbo] BY [userul])
WITH (STATE = ON)
GO

---

Sorin Sandu