USE master
CREATE SERVER AUDIT audit1 TO FILE (FILEPATH='E:\SQLAudit')
USE TEST
CREATE DATABASE AUDIT SPECIFICATION SerialPic FOR SERVER AUDIT audit1
ADD(UPDATE,INSERT,DELETE ON dbo.TestPage by dbo)
数据更新等于对聚集索引的更新;
创建完点击启动哦!
USE master
CREATE SERVER AUDIT audit1 TO FILE (FILEPATH='E:\SQLAudit')
USE TEST
CREATE DATABASE AUDIT SPECIFICATION SerialPic FOR SERVER AUDIT audit1
ADD(UPDATE,INSERT,DELETE ON dbo.TestPage by dbo)
数据更新等于对聚集索引的更新;
创建完点击启动哦!