Friday, April 24, 2020

Read Audit file for SQL SERVER

select * from fn_get_audit_file('D:\SQL_AUDIT\Audit-20200424-144933_5CC133E8-7A26-4473-A638-ADBD88A6D173_0_132321940222150000.sqlaudit',
default,
default);


select [statement],[event_time] from fn_get_audit_file('D:\SQL_AUDIT\Audit-20200424-144933_5CC133E8-7A26-4473-A638-ADBD88A6D173_0_132321940222150000.sqlaudit',
default,
default);

No comments:

Post a Comment