Solved

How to create Service Broker in SQL Server

Posted on 2010-08-24
3
646 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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

623 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