<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://blogs.msdn.com/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Sample activated application</title><link>http://blogs.msdn.com/b/sql_service_broker/archive/2010/03/10/sample-activated-application.aspx</link><description>In today’s post we're providing a sample application skeleton that may be used to play with External Activator, as well as serve as a base for writing custom activated applications.</description><dc:language>en-US</dc:language><generator>Telligent Evolution Platform Developer Build (Build: 5.6.50428.7875)</generator><item><title>re: Sample activated application</title><link>http://blogs.msdn.com/b/sql_service_broker/archive/2010/03/10/sample-activated-application.aspx#10401442</link><pubDate>Tue, 12 Mar 2013 03:54:07 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:10401442</guid><dc:creator>Fernando</dc:creator><description>&lt;p&gt;Hello,&lt;/p&gt;
&lt;p&gt;I tried a similar application (created by myself) which will create a new file when the service activate it. But I never see any new file. Can you please provide a complete sample?&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=10401442" width="1" height="1"&gt;</description></item><item><title>re: Sample activated application</title><link>http://blogs.msdn.com/b/sql_service_broker/archive/2010/03/10/sample-activated-application.aspx#10392601</link><pubDate>Mon, 11 Feb 2013 11:34:54 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:10392601</guid><dc:creator>jgauffin</dc:creator><description>&lt;p&gt;I get a 404 page when trying to download the sample&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=10392601" width="1" height="1"&gt;</description></item><item><title>re: Sample activated application</title><link>http://blogs.msdn.com/b/sql_service_broker/archive/2010/03/10/sample-activated-application.aspx#10257645</link><pubDate>Tue, 17 Jan 2012 16:39:37 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:10257645</guid><dc:creator>MR</dc:creator><description>&lt;p&gt;Can you please provide a step by step sample that includes settting up the queues in database and receiving the message using External Activator? &lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=10257645" width="1" height="1"&gt;</description></item><item><title>re: Sample activated application</title><link>http://blogs.msdn.com/b/sql_service_broker/archive/2010/03/10/sample-activated-application.aspx#10250849</link><pubDate>Sat, 24 Dec 2011 18:03:26 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:10250849</guid><dc:creator>mark</dc:creator><description>&lt;p&gt;Following on my previous comment, can you please explain and share the code on how to write a custom external activator *listener*? &lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=10250849" width="1" height="1"&gt;</description></item><item><title>re: Sample activated application</title><link>http://blogs.msdn.com/b/sql_service_broker/archive/2010/03/10/sample-activated-application.aspx#10250848</link><pubDate>Sat, 24 Dec 2011 17:49:06 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:10250848</guid><dc:creator>mark</dc:creator><description>&lt;p&gt;I’m hesitant in using this since the activated application is required to be a console application.&lt;/p&gt;
&lt;p&gt;How would this behave in a non-interactive server environment where there is no logged-on user? Will there be a pop-up command window if there is an interactive user? &amp;nbsp;Will they see a cmd window? what if they close it by-mistake? Furthermore, how can an infinite dequeue &amp;nbsp;loop be avoid in case of failure, I mean what is the exact condition for future activation, the activated application can exit for a variety of reasons, what are your criteria for consecutive activations? &lt;/p&gt;
&lt;p&gt;It seems that a DLL hosting environment would be more appropriate for this… &lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=10250848" width="1" height="1"&gt;</description></item><item><title>re: Sample activated application</title><link>http://blogs.msdn.com/b/sql_service_broker/archive/2010/03/10/sample-activated-application.aspx#10136380</link><pubDate>Thu, 03 Mar 2011 10:10:41 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:10136380</guid><dc:creator>yevlempy</dc:creator><description>&lt;p&gt;Can you provide step by step configuration of external activation in sql server 2005&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=10136380" width="1" height="1"&gt;</description></item><item><title>re: Sample activated application</title><link>http://blogs.msdn.com/b/sql_service_broker/archive/2010/03/10/sample-activated-application.aspx#10114901</link><pubDate>Wed, 12 Jan 2011 19:10:32 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:10114901</guid><dc:creator>Pawel Marciniak</dc:creator><description>&lt;p&gt;@Mark Freeman&lt;/p&gt;
&lt;p&gt;When the ProcessMessage fails, it will/should throw an exception, which will bubble up and eventually leave the &amp;quot;using(SqlTransaction)&amp;quot; block. That will cause the transaction to be rolled back on the server, effectively putting the received message back into the queue. Of course, the error should not crash the app as it does in the sample, but specific error handling is a business logic that cannot be included in a generic sample. The message, however, will not be lost as you&amp;#39;re implying.&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=10114901" width="1" height="1"&gt;</description></item><item><title>re: Sample activated application</title><link>http://blogs.msdn.com/b/sql_service_broker/archive/2010/03/10/sample-activated-application.aspx#10111608</link><pubDate>Tue, 04 Jan 2011 19:13:33 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:10111608</guid><dc:creator>Mark Freeman</dc:creator><description>&lt;p&gt;One significant omission from this sample is handling of a failure in the ProcessMessage method. If that method were to call a web service that was down or otherwise ran into trouble, there is no code to rollback the transaction (to effectively &amp;quot;un-receive&amp;quot; the message so it isn&amp;#39;t lost.&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=10111608" width="1" height="1"&gt;</description></item><item><title>re: Sample activated application</title><link>http://blogs.msdn.com/b/sql_service_broker/archive/2010/03/10/sample-activated-application.aspx#10095024</link><pubDate>Mon, 22 Nov 2010 17:52:37 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:10095024</guid><dc:creator>Pawel Marciniak</dc:creator><description>&lt;p&gt;@Stacy:&lt;/p&gt;
&lt;p&gt;This pattern is useful when you need the external processing (i/o, web request) to be done transactionally with regard to receiving the message. In order to free the connection before proceeding to do the real work, you would have to commit the receive. What if the external processing fails - there&amp;#39;s no easy way to put the message back in the queue for a retry. If you keep the transaction open, you can just do a rollback in such situation and the message is not lost.&lt;/p&gt;
&lt;p&gt;Of course feel free to change the pattern if your particular circumstances don&amp;#39;t require these guarantees - the code was provided for the most common case, but is by no means perfect for all use cases.&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=10095024" width="1" height="1"&gt;</description></item><item><title>re: Sample activated application</title><link>http://blogs.msdn.com/b/sql_service_broker/archive/2010/03/10/sample-activated-application.aspx#10094290</link><pubDate>Sat, 20 Nov 2010 22:29:41 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:10094290</guid><dc:creator>Stacy</dc:creator><description>&lt;p&gt;Since the payload processing is done inside the reader loop, does the the db connection stay open all that time? What if processing takes time, like doing file i/o or a web request, is this the appropriate pattern to use? &lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=10094290" width="1" height="1"&gt;</description></item></channel></rss>