• jstuparitz (9/30/2008)


    Just to provide a complete solution for everyone for George's suggestion see below. We've used this successfully and performance is excellent. For tables with binary/text columns you will need to change trigger a bit.

    Hope this helps. This will only work with Sql Server 2005 and above.

    This is really great. Solves the problem of too much overhead with the OO method, but still allows for a complete ability to see changes to rows.

    Thanks! :w00t: