EXEC sp_configure 'show advanced option' , 1; |
EXEC sp_configure 'c2 audit mode' , '1' RECONFIGURE; |
EXEC sp_configure 'c2 audit mode' , '0' RECONFIGURE; |
EXEC sp_configure 'common criteria compliance enable' ,1; |
select * from sys.traces |
|
-- Reads from a file that is named \\serverName\Audit\HIPPA_AUDIT.sqlaudit |
SELECT * FROM sys.fn_get_audit_file ( 'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\audittrace20130216145422.trc' , default , default ); |
GO |
by: 发表于:2017-09-22 09:44:15 顶(0) | 踩(0) 回复
??
回复评论