Hmmm ... couldn't find the right answer using SQL. Perhaps there is , but it is difficult. I guess I'll use looping anyway ... ;). Thanks guys ...

Thanks David, it works ...

This website is excellent ...

yes, it is possible to set up two way replication. But an extra work need to be done for those primary key identity field. You have to set different seed...