SQL Service Broker synthax is not recognized
ralf
Posts: 4 Bronze 2
in SQL Prompt
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
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:
