To configure the last-chance threshold to automatically abort open transactions, rather than suspend them:
sp_dboption database_name "abort tran on log full", true
If you upgrade from a previous version of Adaptive Server, the newly upgraded server retains the abort tran on log full setting.