Currently, an audit system is setup, using the round robin approach that will cycle through the audit tables automatically via config variable "current audit table" = 0.
All is fine initially, but when server is recycled, no audit records are captured, but the display audit option still indicate the areas should still be recording audit records.
Now the kicker is, if we issue the sp_audit commands once again, everything resumes until next time the system is rebooted...
All is fine initially, but when server is recycled, no audit records are captured, but the display audit option still indicate the areas should still be recording audit records.
Now the kicker is, if we issue the sp_audit commands once again, everything resumes until next time the system is rebooted...