• You can also take a look at Change Data Capture. It can also provide you a complete change history on tables you identify. Like triggers it will be a change to your database as it add items for the tracking of changed data, but you might get a little better justification in that it is built-in SQL Server functionality specifically built for this purpose.

    About Change Data Capture (SQL Server)

    https://msdn.microsoft.com/en-us/library/cc645937(v=sql.110).aspx

    Joie Andrew
    "Since 1982"