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

No comments:

Post a Comment