Max character limit on XML data in the Parameter column of the AuditEvent table.
A customer is seeing "Truncated Yes" in the Event details (as well as in the Parameters column) for SQL audit events that have large image binary string data.
There are 2 reg keys (Agent side) that will allow you to increase these values:
Text Data:
HKLM\SOFTWARE\Quest\ChangeAuditor\Agent\Settings
DWORD Named SqlDlaMaxTextData
Set the value : 17884
From/To data:
HKLM\SOFTWARE\Quest\ChangeAuditor\Agent\Settings
DWORD named SqlDlaMaxFromToData
Set the value : 9692
Please note, increasing the values will mean the event size is larger for those events and, if you have a log of BLOB changes, you could see your database grow more quickly
© ALL RIGHTS RESERVED. Feedback Términos de uso Privacidad Cookie Preference Center