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

Sending and Receiving Messages

Now that you have built the infrastructure needed for our Service Broker application, you need to have a way to actually perform work. In a Service Broker application, all work to be performed is placed on the queues that you have defined. Processing the messages is accomplished by using SEND and RECEIVE. SEND is used to place messages on a queue. RECEIVE is used to take messages off a queue so the messages can be processed.

Sending Messages

In an OLTP system, you submit work to be performed by issuing a DML statement (INSERT, UPDATE, DELETE, MERGE, or SELECT). Since processing DML requests is a synchronous process, a single statement is sufficient to submit work, have the work processed, and receive a response. Service ...

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