vigneshbeece
Mr or Mrs. 500
Points: 569
More actions
July 20, 2017 at 2:42 am
#343645
I have enabled Auditing in SQL Server 2008R2 to monitor DML AND DDL oprations.
Is there any way to load SQL Audit files to database ? or any other method to automatically load audit details directly to database?
John Mitchell-245523
SSC Guru
Points: 148809
July 20, 2017 at 3:54 am
#1951796
How is the audit file structured? Is it CSV, XML, or something else?
John
July 20, 2017 at 4:12 am
#1951798
audit file structure is .SQLAUDIT
Steve Jones - SSC Editor
Points: 736212
July 20, 2017 at 11:18 am
#1951923
This is a Log File format for Windows.
There is a function you can use.
I might search for ways to programmatically read event log data in windows as well. This post might help.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply