SQL Service Broker synthax is not recognized

ralfralf Posts: 4 Bronze 2
Dear Redgate Support!
We are working now with the SQL Service Brokers and are now faced with problems when we use SQL Prompt.
For example if we want to format this snippet

WAITFOR (
RECEIVE TOP ( 1 ) @message_body = CAST([message_body] AS XML)
, @message_type_name = [message_type_name]
FROM [dbo].[BloombergResponseQueue]
WHERE
conversation_handle = @ConversationHandle
),
TIMEOUT 5000;

it puts the keyword conversation_handle in brackets and is claiming this as an error.
Also the objects (queues, contracts, messagetypes, ... ) are not shown in the suggestion lists.
It would be really helpfully if at least the Keywords are not modified, so that the Statement is still working after the reformatting.
Thanks and best regards
Ralf
Tagged:

Best Answer

  • James RJames R Posts: 104 Silver 4
    Hey @ralf ,

    Thanks for your post! I've managed to reproduce this here, we'll look into fixing it next week most likely.

    Best regards,
    James
    Software Engineer
    Redgate Software
Sign In or Register to comment.