Re: Service Broker question
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
"Sean" <[email protected]> wrote in message
> 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
> "type" (meaning not one particular instance but the class itself) and
> 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
> 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
> 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
> the problem does lie somehow within SQL 2005 itself. Not saying I am
> just saying at this point I need to get a deep understanding of all
> possibilities at the SQL 2005 level first.
|<Prev in Thread]
||[Next in Thread>|
- Re: Service Broker question,
Remus Rusanu [MSFT] <=