Error 17871



Message text

There is no segment named '%1!'.


This error occurs when an attempt is made to add, drop, or modify (using sp_addthreshold, sp_dropthreshold, or sp_modifythreshold) a segment that does not exist in the current database.


Run sp_helpsegment to display segment information about the current database. If the segment exists, check that you have spelled it correctly in your procedure. If the segment does not exist and you believe it has been dropped, use sp_addsegment to add it back.

If the requested segment does not exist and you are certain no one has dropped it, run dbcc commands to check the integrity of the database.

Additional information

Refer to “sp_addthreshold” in the Reference Manual: Procedures and “dbcc” in Reference Manual: Commands for additional information.

Versions in which this error is raised

All versions