• You may also want to look into Change Data Capture (CDC)

    http://msdn.microsoft.com/en-us/library/bb522489(v=sql.105).aspx

    B