How to create Service Broker in SQL Server

Hi All,
Can some one tell me the steps to create a service broker b/w 2 databases in SQL Server 2005/2008?
saratcmAsked:
Who is Participating?
 
wolfman007Connect With a Mentor Commented:
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
 
saratcmAuthor Commented:
Thanks 2 both of U
0
All Courses

From novice to tech pro — start learning today.