Program SQL Server 2005’s Service Broker

SQL Server 2005’s versatile Service Broker infrastructure enables asynchronous messaging between databases and server instances, handles database server event notifications, responds to database change notifications, and sends Database Mail. This article from Visual Studio Magazine's June 2006 issue and FTPOnline's .NETInsight Newsletter for June 20, 2006 shows you how to program Service Broker with T-SQL commands.

The article’s sample code includes SQL Server Management Studio (SSMS) projects that demonstrate simple and complex SSB applications, Query Notifications, Event Notifications, and Database Mail. You need SQL Server 2005 Developer Edition, or higher, to run most sample projects because SQL Server Express (SSX) includes the SSB client components only. SSX also lacks support for Database Mail. The SSB client receives messages from or sends messages to or through higher-level SQL Server 2005 editions’ SSB only. However, SSX does support Query Notifications.

Click here to read the article and here to read the June 20, 2006 issue of .NETInsight, which includes the final session lineup for VSLive! New York to be held September 10 to 13, 2006. Sessions feature data access from Microsoft's new "Data Dude" to DLinq. Other topics include ASP.NET data binding, C# methods, VB.NET, and testing.

Technorati: Databases, SQL Server 2005, SQL Server, SQLServer, MSSQL, SQL Server Service Broker, Service Broker, Query Notifications, Database Mail