O'Reilly logo

Microsoft® SQL Server® 2008 Step by Step by Mike Hotek

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Queue Activation

In the simplest form on a Service Broker application, messages wait on a queue until being pulled off by a service to be processed. If additional processing threads are necessary to keep up with the flow of messages, the developer of the Service Broker application will need to code control logic to launch additional work threads.

In addition to being designed for asynchronous processing, Service Broker also provides dynamic scalability. The ACTIVATION clause of a Service Broker queue allows you to associate a stored procedure to a queue. When the STATUS is set to ON, as soon as a message hits the queue, Service Broker will automatically launch the stored procedure to process the message. As messages continue to come into the queue, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required