Hi ,
I am executing a stored procedure by passing parameters from a dataset file.No COMMIT statements are given in the stored procedure. Intention is to rollback all records processed by this job in case of any failure. I have set the transaction size to '0' . My question is whether COMMIT happens if the job gets completed successfully or do we need to explicitly mention this ?
Please suggest...
Commit Frequency of a Stored Procedure Stage
Moderators: chulett, rschirm, roy