●監査作成use mastercreate server audit [sample_audit]to file( filepath = N'c:\temp\sample_audit' ,maxsize = 2 MB);go●有効化alter server audit [sample_audit]with (state = ON)go
●無効化して削除alter server audit [sample_audit]with (state = OFF)godrop server audit [sample_audit];go
●サーバーレベルの監査設定create server audit specification [server_spec]for server audit [sample_audit]add(DATABASE_OBJECT_CHANGE_GROUP),add(SCHEMA_OBJECT_CHANGE_GROUP),add(SERVER_PRINCIPAL_CHANGE_GROUP),add(LOGIN_CHANGE_PASSWORD_GROUP),add(SERVER_ROLE_MEMBER_CHANGE_GROUP),add(SERVER_PERMISSION_CHANGE_GROUP),add(SERVER_OBJECT_PERMISSION_CHANGE_GROUP)with(state = ON)go
●テストCREATE TABLE StudentGP ( StudentGPAID INT NOT NULL IDENTITY(1,1) PRIMARY KEY, StudentID INT NOT NULL REFERENCES Student (StudentID));
●表示SELECT *FROM sys.fn_get_audit_file('C:\temp\sample_audit\sample_audit_2D70ACA0-C548-4E2B-BB2E-1A9ABE0E3AC9_0_133218989975200000.sqlaudit', DEFAULT, DEFAULT);GO