Audit Trail Classic

How do I safely reduce the size of the audit table by deleting transactions
The Audit Trail Classic table in your SQL Server database (zd_Audit) is your to do as you like with. Audit Trail Classic does not have any requirement for t...
Thu, 1 Dec, 2022 at 10:30 AM
How much extra database space does Audit Trail Classic use?
We are asked this question a lot and it is very difficult to answer. The reason is it really depends on how much data entry activity you have. An organisati...
Thu, 1 Dec, 2022 at 10:30 AM
Audit Trail Viewer says registered but the client says not
When you go into Audit Trail Viewer, if you are not registered then you will see a label telling as much. You need to click on the link to send through your...
Wed, 27 Jun, 2018 at 3:52 PM
Audit Trail Classic changes tracked from the database server but nowhere else
There are several causes of this. The fact that it works when you make changes on the server implies that there is nothing incorrect with the SQL Server use...
Thu, 1 Dec, 2022 at 10:56 AM
Despite exceptions records are still imported when Audit Trail is installed
This is a known issue that comes about when using the duplicate checker. When importing data through the regular RE import and using the duplicate check...
Thu, 1 Dec, 2022 at 10:57 AM
How do I archive audit records to a new database table to free up space?
When you have been running Audit Trail Classic for a while the main audit table may become very large. The large the table the slower the lookup of records ...
Thu, 1 Dec, 2022 at 10:58 AM
Out of Memory Exception - Notepads
When saving a constituent or importing data on to a constituent record (through any of import connected to a constituent e.g. constituent appeals, volunteer...
Thu, 1 Dec, 2022 at 10:59 AM
On upgrading Audit Trail Classic, we get the error - Invalid column name 'TopObjectType'.
When changing a full version i.e. from version 2 to 3, Audit Trail Classic must be upgraded in two place. On the server and and the client machine. In t...
Thu, 1 Dec, 2022 at 10:59 AM