I am trying to begin playing with the Service Broker, and I came across the following tutorial which basically does exactly what I need
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? 🙂