Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Activation Stored Proc with Parameters Expand / Collapse
Author
Message
Posted Tuesday, February 09, 2010 6:05 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, April 10, 2014 8:26 AM
Points: 365, Visits: 344
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


  Post Attachments 
SQLQuery23.txt (5 views, 693 bytes)
Post #862366
Posted Tuesday, February 09, 2010 8:01 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Friday, March 28, 2014 2:25 PM
Points: 9,902, Visits: 9,479
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."
Post #862451
Posted Tuesday, February 09, 2010 8:08 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Friday, March 28, 2014 2:25 PM
Points: 9,902, Visits: 9,479
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."
Post #862459
Posted Tuesday, February 09, 2010 8:18 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, April 10, 2014 8:26 AM
Points: 365, Visits: 344
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!
Post #862467
Posted Wednesday, January 23, 2013 12:59 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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.
Post #1410763
Posted Thursday, February 27, 2014 9:51 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, April 12, 2014 11:18 PM
Points: 134, Visits: 336
Me too.
Post #1546189
Posted Thursday, February 27, 2014 9:58 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 10:42 AM
Points: 20,460, Visits: 14,086
mike 57299 (2/27/2014)
Me too.


Same here. It'd be nice.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1546190
Posted Thursday, March 06, 2014 10:26 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Friday, March 28, 2014 2:25 PM
Points: 9,902, Visits: 9,479
Sorry folks, the site has been down for years.

I am attaching a ZIP of what I think was at this link ...


-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."


  Post Attachments 
ServiceBrokerPresentation.zip (7 views, 851.73 KB)
Post #1548386
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse