Importing MS-SQL audit file

[archanabharathi]

Hi,
I have turned on the audit feature in the MS-SQL server. I can currently use the Profiler to view the contents of the audit file. Is there some other way of viewing the audit file contents? For e.g. can I import the the audit file to the MS-SQL database and view them as contents of tables?
Any info is greatly appreciated! Thanks!

 

[mkal]

Create a new table with the Data columns you will be capturing from the trace and save it on a server and database. When creating a new trace on the General tab choose to save it to the table instead of a file.

 

[archanabharathi]

Thanks for the info! Actually, I think it is possible to specify the data columns using "Trace Properties" and the table with those data columns is automatically created when the "Save to table" option is chosen.