Showing posts with label status. Show all posts
Showing posts with label status. Show all posts

Sunday, February 19, 2012

how to stop conversing status?

Once my target service start to process, how can I stop the rest from running?

right now I'm looping sys.conversation_endpoints and run "END CONVERSATION @.dhValue"

Is there a simpler way to stop processing a service without interfering with other services?

I don't understand what you mean by "stopping the rest from running". If you want a way to stop an activated stored procedure from running, you could either kill the spid it is running on, or disable the queue which will cause it to abort.

Rushi

|||

yes, that' s it.

thanks