Solved

How to create Service Broker in SQL Server

Posted on 2010-08-24
3
641 Views
Last Modified: 2012-05-10
Hi All,
Can some one tell me the steps to create a service broker b/w 2 databases in SQL Server 2005/2008?
0
Comment
Question by:saratcm
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 16

Accepted Solution

by:
vdr1620 earned 250 total points
ID: 33517839
0
 
LVL 14

Assisted Solution

by:wolfman007
wolfman007 earned 250 total points
ID: 33522503
When setting up a Service Broker conversation between two databases you need to define

1) a Message Type (defines valid messages for exchange between services)
2) a Contract (specifies types of messages and their direction in a conversation)
3) a Queue (stores messages before sending and after receipt)
4) a Service (addressable endpoint for th service communication
5) a Service Program (processes messages from queues)

have a look at the Service Broker tutorials on MSDN.

Service Broker Tutorials
http://msdn.microsoft.com/en-us/library/bb839489.aspx
0
 

Author Closing Comment

by:saratcm
ID: 33640631
Thanks 2 both of U
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Check ALL SP in database make sure there are no errors 17 71
Database maintenance 36 141
SSMS Imprt data from Excel 7 38
Need more granular date groupings 4 45
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question