Incorrect syntax error near 'RECEIVE'. Expecting CONVERSATION. by Vladimir Moldovanenko

Closed

as Won't Fix Help for as Won't Fix

Type:	Bug
ID:	765631
Opened:	10/1/2012 4:50:59 PM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

Intellisense reports syntax error when there is none.

See also
https://connect.microsoft.com/SQLServer/feedback/details/748673/incorrect-syntax-error-near-receive-expecting-conversation-intellisense-error#details

Note if one adds ";" after BEGIN, error goes away. ";" is not a requirement for this case

Details (expand)

English

SQL Server 2012 - Developer Edition

Developer Tools (SSDT, BIDS, etc.)

Windows 7 Professional

US English

BEGIN

RECEIVE *
FROM [dbo].[SqlQueryNotificationService-c6531650-3f99-40bc-aac3-87f16c90909e]

END

BEGIN
~~~~
RECEIVE *
~~~~~
FROM [dbo].[SqlQueryNotificationService-c6531650-3f99-40bc-aac3-87f16c90909e]

END~

BEGIN

RECEIVE *
FROM [dbo].[SqlQueryNotificationService-c6531650-3f99-40bc-aac3-87f16c90909e]

END

X64

0 attachments

Posted by Microsoft on 10/11/2012 at 11:08 AM

Hi Vladimir,

Thanks for contacting Microsoft. We investigated the issue you reported and while the IntelliSense error is misleading, execution of the script still works. As such, this doesn't meet the bar to fix at this time.

Thanks again for your feedback and apologies for the inconvenience that this issue may have caused you.

Microsoft