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