I am trying to make Audit return logs, but always returns this error:
"item has already Been added. Key in dictionary: 'mndo' Key Being added: 'mndo'"
I used these commands to test with a "test" user.
USE Clinica_Medica
SELECT * FROM TEST WHERE Nome = 'OI';
In Audit the log returns empty and with this error, I tried with the User SA standard, with global policies and the same happens.
My build:
Both are enabled, what I did wrong?
The problem was that the audit profile in the C:/Audits folder, contained files from another instance of MicrosoftSQL db, was causing a conflict, this did not replace the file, I solved it by delting all the files in the folder.