Actually we're using 2005 tools (on a 2005 server environment).

I hadn't really considered replication as the changes we want to propagate are the outcome of minor development updates which we...

...oh and we're talking about a few hundred rows (max) in each table...

Thanks for the replies. We tried Tablediff but got an error in the generated update script which we couldn't understand (see below). The table in question had no "large data...

Throughput is about 50k transactions per day. Each requires a new unique key.

Thanks for the feedback so far. I was curious as to whether the use of an Identity column for the PK would result in a possible bottleneck when several transactions...

I have now granted explicit permissions to that folder to the Network Service account (which SQL uses) and that appears to have resolved the problem - many thanks for your...

Thanks so much for the prompt reply - that's worked!

Infopath looks interesting, but presumably you need Sharepoint server installed to use it? I was hoping to find an application generator or a solution that didn't require the addition of...

You spotted the deliberate error in my test data 😉

Thanks so much for this - I would never have arrived at this solution! This is exactly what I was looking...

Sorry - thanks for the pointer.

The desired results are:

Week_end_date, no_opened, no_closed

Oct 14 2007,4,0

Oct 21 2007,2,3

Oct 28 2007,1,3

Nov 04 2007,5,3

Nov 11 2007,2,3

Nov 18 2007,2,2

Nov 25 2007,0,1

Dec 02 2007,0,1

Table setup is:

--=====...