Dropping a threshold

Use sp_dropthreshold to remove a free-space threshold from a segment. See Reference Manual: Procedures.

The dbname must specify the name of the current database. You must specify both the segment name and the number of free pages, since there can be several thresholds on a particular segment. For example:

sp_dropthreshold mydb, "default", 200