What are the challenges you face when working across database platforms? Take the survey

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

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

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

Best Answer

  • Options
    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,
    Software Engineer
    Redgate Software
Sign In or Register to comment.