sp_dropthreshold

Description

Removes a free-space threshold from a segment.

Syntax

sp_dropthreshold dbname, segname, free_space

Parameters

dbname

is the database from which you are dropping the threshold. This must be the name of the current database.

segname

is the segment whose free space is monitored by the threshold. Use quotes when specifying the “default” segment.

free_space

is the number of free pages at which the threshold is crossed.

Examples

Example 1

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

Usage

Permissions

Only the Database Owner or a System Administrator can execute sp_dropthreshold.

See also

System procedures sp_addthreshold, sp_dboption, sp_helpthreshold, sp_thresholdaction