In the last post Time After Time: Creating a Valid Time Sql Audit Table  we created the basic data structures required for the audit tables To complete the solution  we are now ready to create an audit trigger that will populate the audit_Orders history table every time the main Orders table is modified and discuss how to query to audit table