if MySP_QueueReader is the program activated by MyQueue and
MyQueue.Max_Queue_Read=1, and the codes of MySP_QueueReader is as followed,
create MySP_QueueRead as
begin

After reading the article "A First Look at SQL Server 2005 Service Broker"
by Roger Wolter (http://www.microsoft.com/indonesia/msdn/sqlsvcbroker.asp),
I have a simple question to the scenario one in that article,
Because the Figures in the original article is lost, I put one on my ...

If I create message type more than once (for some reasons), I will get an
error message of "There is already an object named 'xxxxxxxxxx' in the
database.
How to detect if an object is already existed or not?

In trying to learn SB, I have created a simple "Hello World" app as listed
below.  The problem is that no matter how I've futzed with it so far,
nothing ever shows up in the "ktTestReceivingQueue".    If I don't execute
the line, "end conversation @handle ;" then I see the ...

Roger said messages over 40KB are divided into 40KB blocks.  Does that mean
exactly 40960 bytes?  So if I send a byte[] of 40960 bytes, it will be sent
in exactly 1 message?  TIA

First I've heard of it, was just browsing the BOL at and around
http://msdn2.microsoft.com/en-us/library/ms166049.aspx
and don't quite have the picture yet.
Is there a better overview available online?