>SAVE TRAN basically creates a bookmark in the script. If you have to issue a rollback you can specify in the rollback to only roll back to a specific save point. You also want to consider making your script more atomic, maybe splitting it up if it just too big.

What are the factors in here? Is it about the length of the script or the duration of one of its command? Or, else?

Thanks again