Solved

How to create Service Broker in SQL Server

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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

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…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

770 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