Login
Register
All Activity
Questions
Unanswered
Tags
Users
Ask a Question
About Us
986
Questions
785
Answers
Interview Preparation mode
beta
Funny Facebook Status
Enter your email address
All categories
SQL Server Interview Questions and Answers
(197)
SSIS Interview Questions and Answers
(54)
SSRS Interview Questions and Answers
(9)
SSAS Interview Questions and Answers
(29)
.NET Interview Questions and Answers
(186)
Oracle Interview Questions and Answers
(122)
Java Interview Questions and Answers
(32)
UNIX Interview Questions and Answers
(47)
Networking Interview Questions and Answers
(17)
MySQL Interview Questions and Answers
(30)
HR Interview Questions and Answers
(237)
General Interview Questions and Answers
(9)
Other Interview Questions and Answers
(8)
Job Openings
(3)
Greenplum Database Interview Questions and Answers
(5)
Explain the Service Broker components
Nice?
Vote!
asked
1 year
ago
in
SQL Server Interview Questions and Answers
by
Anand
(
1,440
points)
sql-server-interview-question
service-broker
1 Answer
Nice?
Vote!
The following are the components of Service Broker:
Message:
---------------------
The basic unit of information that is transferred in a Service Broker application. These are received by Service Broker, the way they are sent and are guaranteed only for sending and receiving one at a time.
Conversation:
---------------------
After sending a message to Service Broker, a conversation, which is created for a particular task and deleted soon after the ask has been completed. It is the primary information exchange construct in Service Broker.
Queue:
---------------------
All messages are stored in a queue till the processing is completed. It is a special type of table which can be viewed only with SELECT statement on the name of the queue and INSERT, DELETE, UPDATE statements can not be issued. These messages on a queue will certainly persists even a server restarts, thus guarantees the non-loss of the message.
Service:
---------------------
Reading a messages and processing them is the action of service component. It can be a stored procedure or an ad hoc, or a different program which connects to the database server. Every services need to be associated with a queue.
Conversation Groups:
---------------------
The message processing is serializes and correlates the messages by using conversation groups. Each conversation is a member in a conversation group. The core concept is, some of the messages are related to other messages, and the conversation group puts them together in an ordered fashion.
answered
1 year
ago
by
Anand
(
1,440
points)
Related questions
Nice?
Vote!
2
answers
What exactly is SQL Server 2005 Service Broker?
asked
1 year
ago
in
SQL Server Interview Questions and Answers
by
Anand
(
1,440
points)
sql-server-interview-question
service-broker
Nice?
Vote!
2
answers
Can you explain the difference between the INTERSECT and EXCEPT operators?
asked
1 year
ago
in
SQL Server Interview Questions and Answers
by
Anand
(
1,440
points)
sql-server-interview-question
t-sql
operator
Nice?
Vote!
2
answers
Explain the purposes of OPENXML clause sql server stored procedure
asked
1 year
ago
in
SQL Server Interview Questions and Answers
by
siva
(
10,720
points)
sql-server-interview-question
sql-server
openxml
Nice?
Vote!
1
answer
As a Network Administrator, which components of SQL Server do you want to secure?
asked
1 year
ago
in
SQL Server Interview Questions and Answers
by
R
(
19,530
points)
sql-server-interview-question
networking-interview-question
security
Nice?
Vote!
1
answer
Explain how to make remote connection in database
asked
1 year
ago
in
SQL Server Interview Questions and Answers
by
KrishnaMachiraju
(
7,980
points)
sql-server-interview-question
sql-server
remote