You can use the SQLProcsTimeout defaults file setting to limit the amount of time a stored procedure will be allowed to run before control is returned to the application. By default, Dexterity will wait 300 seconds (5 minutes) for a stored procedure to run to completion.
If you want Dexterity to wait indefinitely for a stored procedure to run, you must include this setting in the defaults file and set its value to 0.
While most stored procedures should run to completion within the 5 minutes allotted by default, you will need to include this setting in your defaults file and set it to a higher number of seconds if your stored procedures are consistently timing out.