🚀 go-pugleaf

I have two stand alone nt4 server with tcp/ip connect to the internet (with
single ip address), both stand alone nt4 server have installed sql 6.5
server. These two machines will runing at different branch(in different
country), a single table called "helloworld" will always update, insert and
delete in these two different machines. The table "helloworld" will have a
single primary key named "clientname".

===================================
Question 1/ Since two machines will always update the table "helloworld". How
can I create two ways of replication?

	My concetp is in 	Machine A - create publicate to Machine B
				Machine A - create subscript to Machine B
				Machine B - create publicate to Machine A
				Machine B - create subscript to Machine A
	Is my concept right, or please give me some pointors. Thanks

===================================
Question 2/ How can I connect "SQL server B" from "SQL server A" through
WAN(tcp/ip) so I can set the replication between two SQL servers?

	I have read some faq that they will set the SQL executive task to run
as an account which maps directly (username / password) to an account on the
other domain.	     This is a good pointor but I still do not know how to
set the Sql executive task. Could you give me some more details of how to do
it?

	Or if you have any suggestion please tell me.

===================================
Question 3/ What happen if Machine A and Machine B have inserted the same
"clientname"  - "bill" at the same time. While they're replicate, the same
primary key will be exist, how can I prevent this problem.

===================================
Thank you Thank you, Thank you for the help.

LaHaHaHaHa

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own