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.
