1) I have the Beta Preview of Roger Wolter's book on the subject. Has anything major changed from the beta version to the full version (of the book as well as the product)
2) I want to build a front-end that queues requests for processing that is ultimately done by a standalone console application. The console app knows nothing about SQL Server 2005, so the database will have to fork/execute this app, pass it arguments on its command line, and pick up the result (written to either standard output or standard error) when it finishes. Is this possible with Service Broker If so, how
TIA
Andrew
2 questions from a newbie who's trying to work out if Service Broker is the right thing to use
Michael Shorten - MB Limited
lukics
1) It is OK to use Roger's beta preview book on the released product.
2) The processing have to be like this:
BEGIN TRANSACTION
RECEIVE ...
PREPARE ARGUMENTS
LAUNCH EXE
INTERPRET RESULT
SEND RESPONSE
COMMIT
While it is possible to use internally activated CLR procedures to achieve this, I'd recommend to have a look at the External Activator Sample at http://www.gotdotnet.com/codegallery/codegallery.aspx id=9f7ae2af-31aa-44dd-9ee8-6b6b6d3d6319. You'd have to write an external EXE reader that does the same actions as listed before (receive, launch exe, respond, all in one transaction)
HTH,
~ Remus