Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Service Broker (2005)
 Possible Service Broker Solution?

Author  Topic 

DBACgy
Starting Member

1 Post

Posted - 2006-05-29 : 12:34:46
So I'm wanting to try out the Service Broker for 2005 and I think I found a situation where I would want to use it.

Can someone tell me if they think Service Broker might be a good option to use?

1 Customer Table shared between many Servers. Any server can add/update Customer information and those changes need to propogate to the other servers Customer Table.

Would Service Broker be a good option to solve this problem?

fordc03
Starting Member

3 Posts

Posted - 2006-07-17 : 16:19:00
So you're saying that you have 1 Table on Server A, and that Servers B, C, D, and E all reference that one table?

And then you are "replicating" that "Master" Customer table to all the other servers?

Am I understanding correctly?
Thanks,
Christopher
Go to Top of Page

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2006-07-17 : 16:35:45
398 reads!
Noone has a clear view on this?
Go to Top of Page

fordc03
Starting Member

3 Posts

Posted - 2006-07-17 : 20:58:54
I have a few views on this. :) I just want to make sure I understand the question :)
Go to Top of Page

om
Starting Member

8 Posts

Posted - 2006-09-01 : 15:56:44
thanks for ur suggestion
Go to Top of Page

om
Starting Member

8 Posts

Posted - 2006-09-01 : 16:55:16
quote:
Originally posted by om

no body give clear vision

Go to Top of Page

om
Starting Member

8 Posts

Posted - 2006-09-01 : 16:56:30
quote:
Originally posted by rockmoose

398 reads!
None has a clear view on this?

Go to Top of Page

om
Starting Member

8 Posts

Posted - 2006-09-01 : 16:58:06
quote:
Originally posted by fordc03

oh you are right :)

Go to Top of Page
   

- Advertisement -