摘要 |
An audit system structured for auditing at least one operational table of a transaction system during an audit event is provided. In an embodiment, the audit system includes at least one audit history table operatively associated with the operational table of the transaction system, and each audit history table includes at least one database trigger configured for monitoring one or more data changes in the operational table. The database trigger generates an XML message for a monitored data change and transmits it to an SQL server service broker queue, which activates a procedure to transmit the message to at least one subscriber service broker queue, which activates an asynchronous data processing service for the monitored data change. |