thanks for the reply.

We are using SQL 2008 R2.

I shall experiment with a full reload from scratch every day rather than just updates.

As each table has a timestamp as well as a primary key field I was hoping I could quickly just compare those 2 fields for new/updated/deleted records rather than checking all the fields I am interested in as over time I'm sure new fields will be asked for so I will need to update the check script but with the timestamp I wouldn't have to.