Changing or Deleting Thresholds

To change or delete thresholds, use sp_helpthreshold, sp_modifythreshold, and sp_dropthreshold.


For information about existing thresholds.


To associate a threshold with a new threshold procedure, free-space value, or segment. (You cannot change the free-space value or segment name associated with the last-chance threshold.)

Each time a user modifies a threshold, that user becomes the threshold owner. When the threshold is crossed, the SAP ASE server executes the threshold with the permissions the owner had at the time he or she modified the threshold, minus any permissions that have since been revoked.


To drop a threshold from a segment.