Dropping a Threshold

Use sp_dropthreshold to remove a free-space threshold from a segment.

The sp_dropthreshold dbname parameter 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

See the Reference Manual: Procedures.