<p>I'm running a long process stored procedure.</p>

<p>I'm wondering if in case of a timeout or any case of disconnection with the database after initiating the call to the stored procedure. Is it still working and implementing the changes on the server?
­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­</p>

[{'answer_id': 25146, 'author': 'Douglas Tosi', 'author_id': 626, 'author_profile': 'https://Stackoverflow.com/users/626', 'pm_score': 1, 'selected': False, 'text': '<p>It depends on the server I guess.<br>\nI know Firebird will detect disconnected clients and stop working.<br>\nAnyway if the client is not there to commit at the end of the job the changes should be rolled back by the server.</p>\n'}, {'answer_id': 25150, 'author': 'Yaakov Ellis', 'author_id': 51, 'author_profile': 'https://Stackoverflow.com/users/51', 'pm_score': 3, 'selected': True, 'text': '<blockquote>\n  <p>Anyway if the client is not there to commit at the end of the job the changes should be rolled back by the server.</p>\n</blockquote>\n\n<p>In other words, if you have a stored procedure making changes to the database and there is a possibility that the connection might disconnect in the middle, be sure to enclose all changes within a transaction.</p>\n'}, {'answer_id': 25513, 'author': 'Eric Z Beard', 'author_id': 1219, 'author_profile': 'https://Stackoverflow.com/users/1219', 'pm_score': 0, 'selected': False, 'text': '<p>I would suggest running your profiler on the database and watching the activity, and also create a basic test case so that you know for sure what happens.  The outcome is dependent on your database and what you are using to connect to it.</p>\n'}]
['https://Stackoverflow.com/questions/25142', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/-1/']