Service Broker code fails to parse ...

DanMoran

When I write Service Broker code, and choose "Lay Out SQL" from the menu, it fails with the error "SQL Refactor was nable to lay out this script because some errors were found while it was being parsed. These errors have been highlighted."

The code highlighted is standard Service Broker code that works fine and parses fine using the Management Studio parser --

BEGIN DIALOG @Dialog
FROM SERVICE @TargetService
TO SERVICE '//mysrv/Workflow/Client'
ON CONTRACT [//mysrv/Workflow/Contract] WITH ENCRYPTION = OFF;

But SQL Refactor chokes on it. Since I'm working mostly with Service Broker these days, this is a problem for me ...

Simon C

I'm afraid the parser in the current version of refactor doesn't accept variable names for the FROM SERVICE clause. I've added this to the SQL Compare Engine (which contains the parser) bug tracker (SC-3786) to be fixed for v7, which the next version of refactor will include. As a workaround, you could put the target service directly into the FROM SERVICE clause rather than having it as a variable.

Simon Cooper

DanMoran

OK, that's a workaround I can live with. Thanks for the quick response.