The stored procedure sp_send_dbmail is intended to send emails directly from SQL Server. One of benefits using sp_send_dbmail puts messages into a message queue rather than directly sending them to re
From the previous post, Step 4: External Activator Service Configuration, we have configured Service Broker (SB) External Activator (EA). In this article, we are going to start the Service and run sme
From the previous post, Step 3: External Activator Application Development, we have developed a console application activated by Service Broker (SB) External Activator (EA). In this article, we are g
From the previous post, Step 2: SQL Server Setup, we have created Service Broker (SB) objects including stored procedures and triggers. In this article, we are going to develop the actual application
From the previous post, Step 1: Service Broker External Activator Service Setup, we have installed a Windows Service application for Service Broker External Activator (EA). In this article, we are goi
In SQL Server, unlike triggers.aspx), Service Broker (SB) works asynchronously. The benefits of using SB can be found in this document.aspx). One of great benefits using SB is that it is not only coms