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.

Auditing

Values in event and extrainfo columns from the sysaudits table are:

Event

Audit option

Command or access audited

Information in extrainfo

38

exec_procedure

Execution of a procedure

  • Roles – Current active roles

  • Keywords or options – NULL

  • Previous value – NULL

  • Current value – NULL

  • Other information – All input parameters

  • Proxy information – Original login name, if set proxy in effect

See also

System procedures sp_addthreshold, sp_dboption, sp_helpthreshold, sp_thresholdaction