Have a happy New Year. Go spend the night with family.
That’s what I’m doing tonight.
Denny
Happy New Year!!
| Published On: 2008-12-31 | By: Denny Cherry |
- Home
- Consulting
- Training
- Publications
- Blog
- Books
- Case Study
- Newsletter
- 2019-05-30 Out of Office Reply: When the CEO Takes Emergency Leave
- 2019-03-19 Power BI: Where should data live?
- 2018-11-19 What’s the difference between the cloud data platform options?
- 2018-09-18 How can Azure customers save money thru performance tuning?
- 2018-07-11 Moving to the Cloud & Cloud Features
- 2018-04-10 The Most Important Azure Services For Your Business
- 2018-01-16 Join us for a Database Security Webcast January 19th
- 2017-09-25 SQL Server 2017 Experts Review
- 2017-08-10 Save On Cloud Licensing
- 2017-05-05 IT Security
- 2017-03-16 SQL Server 2016, The BI Advantage
- 2017-02-09 R Services in SQL Server 2016
- 2016-12-20 Webcast, Expert Tips and More
- 2016-08-02 Azure VS. Amazon RDS
- 2016-07-12 The ROI on SQL Server 2016
- White Papers
- About Us
- News
- Applications
- Contact Us
Search Our 1750+ Blog Posts
Watch our most recent webcast
Register for our Webcast on March 12th, 2020 at 11 am Pacific / 2 pm Eastern where Denny Cherry will cover what steps a copy go through in advance of a Ransomware attack so that you are protected from an attack; what a Ransomware can (and probably will) go after; and what you can do after the fact to bring your company back after a Ransomware attack, without paying the ransom.
Next Webcast
Watch our webcast on Friday November 15th, 2019 at 2pm Eastern / 11am Pacific where Meagan Longoria and Kerry Tyler will present their webcast “Is it time for an SSIS checkup?”.
Watch Now
See All Our Live and Recorded Wedbcasts
Recommended Partner Programs
Hi, I went through your tip “Configure SQL Server Service Broker for sending stored procedure data” at http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1310106,00.html.
I found it very interesting and informative. However, whenever I try executing the step to retreive data from the queue
************
DECLARE @dialog_handle UNIQUEIDENTIFIER, @XMLData XML ;
RECEIVE TOP (1) @dialog_handle = conversation_handle, @XMLData = CAST(message_body AS XML)
FROM [tcp://SearchSQLServer/SampleQueue]
END CONVERSATION @dialog_handle
SELECT @XMLData
****************************************
I get the following error :
Msg 8418, Level 16, State 1, Line 4
The conversation handle is missing. Specify a conversation handle.
I tried BOL, googled but can not find good information.
Thanks in advance for your help
In this syntax the error means that there was no message received and the @dialog_handle variable was NULL.
When I’m writing T/SQL to handle Service Broker messages I put logic in just after the receive to see if the @dialog_handle variable is null, and if it is to break out of the code as that means that there was no message processed.
If you aren’t sure if there are messages to process you can do SELECT statements against the queue and look at the messages without receiving them or prcessing them.