[Top] [All Lists]

Re: Service Broker question

Subject: Re: Service Broker question
From: "Remus Rusanu [MSFT]"
Date: Thu, 3 Aug 2006 08:27:10 -0700
Newsgroups: microsoft.public.sqlserver.notificationsvcs, microsoft.public.sqlserver.servicebroker
There is a Service Broker newsgroup at 
microsoft.public.sqlserver.servicebroker and a Service Broker forum at

Yes, it is possible that an application to have bugs and create 
conversations that stuck forever. But the dba has means at its disposal to 
clean up such stuck conversations. The fix is, of course, to fic the 

This posting is provided "AS IS" with no warranties, and confers no rights.

~ Remus Rusanu

SQL Service Broker,SQL.90).aspx

"Sean" <[email protected]> wrote in message 
news:[email protected]
> 1. is this the best place to ask a service broker question?
> Forgive me Service Broker experts I am speaking outside of my realm here.
> Is it possible that a component "type" could automatically creates a
> "conversation" in the Service Broker and if not well designed that
> conversation gets stuck and never closes. So specifically I have a 
> component
> "type" (meaning not one particular instance but the class itself) and 
> anytime
> I reference Update to a specific table with a sproc of any signature I get
> the exact same error which looks to me that it is refereeing to an old 
> sproc.
> The basic error is that to many parameters are being specified which is
> because the table contains one extra column then the old sproc however I 
> have
> created sprocs with only a few parameters and get the same error.
> Now granted it could be a developer error on any infinite levels however I
> ask a favor. That favor is to assume I have done my part correctly and 
> that
> the problem does lie somehow within SQL 2005 itself. Not saying I am 
> wrong,
> just saying at this point I need to get a deep understanding of all
> possibilities at the SQL 2005 level first.
> Thanks!

<Prev in Thread] Current Thread [Next in Thread>
  • Re: Service Broker question, Remus Rusanu [MSFT] <=