Threaded windows Service

[João Santa Bárbara]

Hi all, i need some techinal advise.
i have create a windows service, this service is made todo a simple task
Replicate data between several SQL servers.
in this service, i need to have 5 instances running at the same time. some
thing like this

Table 1 - > running 10 minutes
Table 2 - > running 2 minutes
....
....

do i need to create an multithreaded Service ???

one other thing ..
each table only runs once at the time, i need to run the second time the
Table 1 when the first has stoped ..

can someone help me ..
THks

JSB

PS: any sample .?

 

[Guest]

SQL 2000 has a built in Data shipping component I would look into wether the built in functionality meets your needs.