Dropping the threshold action procedure

To discontinue threshold action procedure, clear the threshold using the sp_dropthreshold, or use sp_dbextend with the clear option. For information about sp_dropthreshold, see the Reference Manual.