Adding, Changing, and Deleting Thresholds

The database owner or system administrator can create additional thresholds to monitor free space on any segment in the database.

Additional thresholds are called free-space thresholds. Each database can have as many as 256 thresholds, including the last-chance threshold.

sp_addthreshold, sp_modifythreshold, and sp_dropthreshold allow you to create, change, and delete thresholds. All of these procedures require you to specify the name of the current database.