Removes a free-space threshold from a segment.
sp_dropthreshold dbname, segname, free_space
is the database from which you are dropping the threshold. This must be the name of the current database.
is the segment whose free space is monitored by the threshold. Use quotes when specifying the “default” segment.
is the number of free pages at which the threshold is crossed.
Removes a threshold from segment1 of mydb. You must specify the database, segment, and amount of free space to identify the threshold:
sp_dropthreshold mydb, segment1, 200
You cannot drop the last-chance threshold from the log segment.
You can use the no free space acctg option of sp_dboption as an alternative to sp_dropthreshold. This option disables free-space accounting on non-log segments. You cannot disable free-space accounting on log segments.
Only the Database Owner or a System Administrator can execute sp_dropthreshold.
System procedures sp_addthreshold, sp_dboption, sp_helpthreshold, sp_thresholdaction