sqlserver查詢分析器建立sql查詢日誌

標籤：

USE [master]
GO

/****** Object: Audit [ServerAuditDB] Script Date: 2016-04-28 16:02:58 ******/
CREATE SERVER AUDIT [ServerAuditDB]
TO FILE
( FILEPATH = N‘E:\ServerAuditDB\‘
,MAXSIZE = 0 MB
,MAX_ROLLOVER_FILES = 2147483647
,RESERVE_DISK_SPACE = OFF
)
WITH
( QUEUE_DELAY = 1000
,ON_FAILURE = CONTINUE
,AUDIT_GUID = ‘66830c88-99fd-442a-8df2-2f292e25bc5b‘
)
ALTER SERVER AUDIT [ServerAuditDB] WITH (STATE = ON)
GO
鄧小茄 16:04:02
小茄
USE [ceshi]
GO

CREATE DATABASE AUDIT SPECIFICATION [DatabaseAuditSpecification-ceshi]
FOR SERVER AUDIT [ServerAuditDB]
ADD (DATABASE_OBJECT_CHANGE_GROUP),
ADD (SELECT ON OBJECT::[dbo].[digui] BY [public]),
ADD (SELECT ON OBJECT::[dbo].[Customer] BY [public])
WITH (STATE = ON)
GO

sqlserver查詢分析器建立sql查詢日誌