Chapter 15: Managing Free Space with Thresholds

Using abort tran on log full to abort transactions

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.