Audit File

• ramana3327

  SSCoach

  Points: 19700

  More actions

  October 30, 2014 at 12:54 pm

  #298009

  Hi,

  Under the Audit tabe in the Security Node, I can see they enabled one audit. I right click and select the option view auditlog. It is showing initializing the log more than 30 min.

  I tried to open directly from the audit file. I selected through notepad but it is not opening. How can I read audit file?

• ramana3327

  SSCoach

  Points: 19700

  More actions

  October 30, 2014 at 1:27 pm

  #1755909

  It is working by using this

  SELECT * FROM sys.fn_get_audit_file ('\\serverName\Audit\HIPPA_AUDIT.sqlaudit',default,default);

  GO