InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 04:56:27 GMT20http://www.sqlservercentral.com/Forums/Topic862366-1281-1.aspxHi Barry, Your "You can download it [b]here[/b]." link doesn't work. I'd love to see that example. Thanks.Wed, 23 Jan 2013 12:59:14 GMTkcordellhttp://www.sqlservercentral.com/Forums/Topic862366-1281-1.aspx[quote][b]Bob Hovious (2/9/2010)[/b][hr]As a side note, when I was learning Service Broker a couple of years ago, I read over thirty articles, tutorials and walkthroughs, including many from Microsoft. And yet I could not get a single one of them to work!What I discovered later was that every one of those articles either had significant mistakes or, more often, left out important details that made it impossible to get their examples to work (Microsoft's examples have since been corrected, mostly). In response to this I made up my own presentation, and example code to teach Service Broker, and especially to point out all of the typical mistakes and traps that first-time SB developers get caught by. You can download it [url=http://movingsql.com/dnn/LinkClick.aspx?fileticket=c7EJbXre%2fLg%3d&tabid=125&mid=911]here[/url]. I promise you that it works.[/quote]Thank you very much! I will check out your examples and slides!Tue, 09 Feb 2010 08:18:56 GMTSQL STEWIEhttp://www.sqlservercentral.com/Forums/Topic862366-1281-1.aspxAs a side note, when I was learning Service Broker a couple of years ago, I read over thirty articles, tutorials and walkthroughs, including many from Microsoft. And yet I could not get a single one of them to work!What I discovered later was that every one of those articles either had significant mistakes or, more often, left out important details that made it impossible to get their examples to work (Microsoft's examples have since been corrected, mostly). In response to this I made up my own presentation, and example code to teach Service Broker, and especially to point out all of the typical mistakes and traps that first-time SB developers get caught by. You can download it [url=http://movingsql.com/dnn/LinkClick.aspx?fileticket=c7EJbXre%2fLg%3d&tabid=125&mid=911]here[/url]. I promise you that it works.Tue, 09 Feb 2010 08:08:50 GMTRBarryYounghttp://www.sqlservercentral.com/Forums/Topic862366-1281-1.aspxThen, unless it had all [i]optional[/i] parameters, the tutorial was wrong. Service Broker passes [i][b]no[/i][/b] parameters to the activation procedure, so if it requires any, the activation will fail.Tue, 09 Feb 2010 08:01:24 GMTRBarryYounghttp://www.sqlservercentral.com/Forums/Topic862366-1281-1.aspxI am trying to begin playing with the Service Broker, and I came across the following tutorial which basically does exactly what I needhttp://www.sql-server-performance.com/articles/dev/service_broker_p2.aspxhowever, I am not sure if there is a flaw in the tutorial or if I am missing somerthing. I have attached the code I am using. I am running on a SQL Server 2005 box and when I execute the code, I get the following error[b]Msg 9653, Level 16, State 1, Line 2The activation stored procedure 'spLogMessage' is invalid. Activation stored procedures cannot require parameters.[/b]but in the tutorial, the activation stored proc has parameters. Can someone please help me out? :)Thanks!MichaelTue, 09 Feb 2010 06:05:27 GMTSQL STEWIE