Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

I made this Service Broker application: http://pastebin.com/M1jZg2Pt

I want to run stored procedure spInsertLogLine and for a record to end up in table log_line.

I do 

exec [broker].dbo.spSendLogLine
  @device_id = 'devid1',
  @application_name = 'appname1',
  @application_user_name = 'usrnme',
  @log_line_dt = 1, --@log_line_dt = GETDATE(), fails
  @log_line_message = 'this is the log line'

I end up with a message in queue qReceiveLogLine with status 3 and nothing in queue qInsertLogLine or in table log_line.

I'm very new to Service Broker. What am I doing wrong?

share|improve this question
Answered by my colleague at stackoverflow.com/a/14957272/127434 .. – cja Feb 19 at 12:20
Please don't cross-post your questions. Thanks. – Jon Seigel Feb 19 at 14:28
Doing so increases visibility of my questions both to potential answerers and to those with the same problem in future. – cja Feb 19 at 14:40
Please see this: meta.stackoverflow.com/questions/64068/… – Jon Seigel Feb 19 at 17:38

closed as too localized by Jon Seigel, Leigh Riffel, RolandoMySQLDBA, Mark Storey-Smith, Paul White Feb 19 at 23:44

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, see the FAQ.