• In 2008 and 2008 R2 (might only be enterprise), there is the change data capture configuration that could also be put in place.

    http://msdn.microsoft.com/en-us/library/bb522489.aspx

    Regards,

    Steve