Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Ending Conversations in Async setup Expand / Collapse
Author
Message
Posted Thursday, March 21, 2013 9:15 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 9, 2013 8:19 AM
Points: 179, Visits: 751
How many sprocs using begin or End conversation are needed in an ASYNC SB setup.
I currently have 2 t the INITIATOR and the Target. As the Initiator ends the conversation first the
Target gets no response to its end conversation.
Do I need another procedure in the conversation so that the conversation will end properly and not leave endpoints/TOs in the Tempdb.
Post #1433854
Posted Thursday, March 21, 2013 9:27 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 9, 2013 8:19 AM
Points: 179, Visits: 751
How do you write an asynchronous SB. So that it doesn't fill up tempdb.
Post #1433863
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse