excellent, will try.

thanks willem

Not sure what you need, the tables are existing tables.

the cursor i use is here

DECLARE CRSCODES CURSOR FOR

SELECT NR, POSINFO FROM SELECTIES.DBO.NUT_EXP WHERE CODE=''

OPEN CRSCODES

declare @NR INT

,@AANTALRECS INT

,@POSINFO VARCHAR(2)

,@CODE VARCHAR(32)

,@URL...

here is some sample data

tblcodes:

codeid - code - adr_id

1 - CB4560460D5946C49D9B286048CC11A7 0

2 - 5953BE4521634863B9D03137B7DBA3C4 0

3 - 97D40E6B7AF545AE94ED13DF1AF1C27F 0

tblcustomer

adr_id code

2568922 0

2560812 0

as you can see the adr_id in the first table...

Steve Jones - Editor (10/29/2009)

---

You can have both replication partners update data in merge or in bidrectional transactional replication. You need to really think through what to do if there...

to clarify, is it possible at all to have two 2008 standard servers replicate where server A can be updated and inserted en server B also ?

there are just 4...

that seems like an good idea to me.

would the option database mirroring work, with an snapshot for the queries you think ?

hourly data would be just fine as long as their updates proceed to the websites db then.

we are in the process of improving a lot of queries they use, including...

indeed they are geological apart. the online db (website) is not up and running.

the two users do a lot of heavy queries that sometimes cause the regular users to experience...