Thanks for your response. I started to look at Change Data Capture (CDC) only to be stopped by the fact that it is an Enterprise edition only feature. The servers in question are Standard edition.

Thanks too for the article.