|
|
|
SSC Veteran
      
Group: General Forum Members
Last Login: Yesterday @ 9:00 AM
Points: 291,
Visits: 320
|
|
I am trying to begin playing with the Service Broker, and I came across the following tutorial which basically does exactly what I need
http://www.sql-server-performance.com/articles/dev/service_broker_p2.aspx
however, 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
Msg 9653, Level 16, State 1, Line 2 The activation stored procedure 'spLogMessage' is invalid. Activation stored procedures cannot require parameters.
but in the tutorial, the activation stored proc has parameters. Can someone please help me out? :)
Thanks! Michael
|
|
|
|
|
SSCrazy Eights
        
Group: General Forum Members
Last Login: Wednesday, June 12, 2013 11:17 AM
Points: 9,855,
Visits: 9,376
|
|
Then, unless it had all optional parameters, the tutorial was wrong. Service Broker passes no parameters to the activation procedure, so if it requires any, the activation will fail.
-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung Proactive Performance Solutions, Inc. "Performance is our middle name."
|
|
|
|
|
SSCrazy Eights
        
Group: General Forum Members
Last Login: Wednesday, June 12, 2013 11:17 AM
Points: 9,855,
Visits: 9,376
|
|
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 here. I promise you that it works.
-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung Proactive Performance Solutions, Inc. "Performance is our middle name."
|
|
|
|
|
SSC Veteran
      
Group: General Forum Members
Last Login: Yesterday @ 9:00 AM
Points: 291,
Visits: 320
|
|
Bob Hovious (2/9/2010)
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 here. I promise you that it works.
Thank you very much! I will check out your examples and slides!
|
|
|
|
|
Forum Newbie
      
Group: General Forum Members
Last Login: Monday, April 08, 2013 6:16 PM
Points: 1,
Visits: 23
|
|
| Hi Barry, Your "You can download it here." link doesn't work. I'd love to see that example. Thanks.
|
|
|
|