SQL Server uses Audit to Audit SQL statements for specific table operations

1. Create an SQL Server audit

USE master

GO

Create server audit ServerAudit

To file (FILEPATH = 'd: bakAudit ', MAXSIZE = 1 GB)-change the FILE path

WITH (ON_FAILURE = CONTINUE );

GO

2. Create server audit specifications

USE slxsina

GO

Create database audit specification product_nostandard for server audit ServerAudit

ADD (UPDATE, INSERT, delete on dbo. product_nostandard by dbo)

GO

3. Activate SQL Server audit

USE master

GO

Alter server audit ServerAudit

WITH (STATE = ON)

4. View audit data

SELECT event_time,

Succeeded,

Server_principal_name,

[Object_name],

[Statement]

FROM sys. fn_get_audit_file ('d: bakAudit * ', NULL, NULL)

WHERE database_name = 'slxsina ';