Reports the segment, free-space value, status, and stored procedure associated with all thresholds in the current database or all thresholds for a particular segment.
sp_helpthreshold [segname]
is the name of a segment in the current database.
Shows all thresholds on the log segment:
sp_helpthreshold logsegment
Shows all thresholds on all segments in the current database:
sp_helpthreshold
Shows all thresholds on the default segment. Note the use of quotes around the reserved word “default”:
sp_helpthreshold "default"
sp_helpthreshold displays threshold information for all segments in the current database. If you provide the name of a segment, sp_helpthreshold lists all thresholds in that segment.
The status column is 1 for the last-chance threshold and 0 for all other thresholds. Databases that do not store their transaction logs on a separate segment have no last-chance threshold.
Any user can execute sp_helpthreshold. Permission checks do not differ based on the granular permissions settings.
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 |
|
System procedures sp_addthreshold, sp_dropthreshold, sp_helpsegment, sp_modifythreshold, sp_thresholdaction
