Merge Replication and MSDE 2000

Hello..I am going to implement Merge Replication with MSDE 2000.
please let me know how many users MSDE 2000 can burden the workload. It
will degrade the preformance if more than 5 concurrent user will start
work on it concurrently.
What is the procedure in order to implement merge Replication on MSDE
2000.
Pls help me as soon as possible
Thanks in Advance,
Jayesh Patel
(jayesh@.infoworldpune.com)
its 8 simultaneous workloads. So if you are using connection pooling this
could mean many more users the 8, but it depends on what sort of work they
are doing. Work which takes a long time might mean you get throttling with 8
simultaneous connections. Work which completes in ms and work which takes
advantages of connection pooling could mean many more than 8 simultaneous
users.
To implement replication use any of the tutorials on the web, and run
profiler to capture the commands. Then apply these commands using osql.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Jayesh" <dba.jayeshpatel@.gmail.com> wrote in message
news:1125318990.896170.122400@.g47g2000cwa.googlegr oups.com...
> Hello..I am going to implement Merge Replication with MSDE 2000.
> please let me know how many users MSDE 2000 can burden the workload. It
> will degrade the preformance if more than 5 concurrent user will start
> work on it concurrently.
> What is the procedure in order to implement merge Replication on MSDE
> 2000.
> Pls help me as soon as possible
> Thanks in Advance,
> Jayesh Patel
> (jayesh@.infoworldpune.com)
>
|||Thanks a lot for reply.
Can you guide me how to implement replication between SQL server and
MSDE ?
We have to setup Merge Replication between three continents.
1) asia
2)america
3) Europe
These 3 continents will be act as publisher and suscriber.
(by merging them)
But within one continent , there might be many more countries.
Country contains variuos city. City level database would be running on
MSDE.
Is it possible to replicate data this city level data with country as
well continent level.
Thanks in Advance,
Jayesh Patel