Hi,
Does anyone have a definitive guide or understanding of how the different procedure 'on stop' behaviors work? I am most interested in understanding the implications of "Must be executed until the end." My current issue is that, if a procedure is running and a data reader kicks off (even in another database), the procedure stops, with the message that it failed due to "frozenprocedures.dbo" I am wondering if i can force the procedure to wait to continue by choosing a different 'on stop' behavior. Any thoughts are appreciated.