SQL Server触发器在轨迹保留中的应用

为了便于对重要数据进行监测和保护，提出了一种应用触发器实现轨迹保留的方法。通过在数据库中建立一个冗余数据表记录数据修改轨迹，数据变化时触发器自动将修改前的数据副本写人冗余数据表，由于冗余数据表是个关系型数据集，提取和查看方便，多级数据回溯与恢复也易于实现。实践表明，该方法具有很好的效果。

Application of SQL Server Trigger in Tracks Reservation

In this paper,for easy to protect and monitor important data, propose a method that trigger was applied to achieve the goal of tmcksreservation. Via designing a special redundant table in database which can record the data modification tracts, whenever data change, the trigger can write a former data backup into this redundant table automatically. Since it is a relational record set, it is convenient to query or select, and to realize a series of UNDO hackdating and data rescue. Experimental results and the practice show that this method is available and well effective.