Changing or Deleting Thresholds

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

ProcedureDesription
sp_helpthreshold

For information about existing thresholds.

sp_modifythreshold

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.

sp_dropthreshold

To drop a threshold from a segment.