SQL Server 2005 introduces Service Broker, an extensive mechanism for supporting asynchronous messaging with SQL Server.

The very heart of Service Broker is the new SQL Server object: QUEUE. To utilize just the queue you still have to go through the service broker and do all the extensive stuff which you may or may not need.

The minimum steps you need to create a queue are:

1. Create a message type
2. Create a contract
3. Create a queue
4. Create a service

Make sure there is a master encryption key available in your database, otherwise the message won't get send.

I've created stored procedures for sending en receiving messages. Works quite well. I'll post some SQL code later.