Specifying a new last-chance threshold procedure  Creating a free-space threshold for the log segment

Chapter 15: Managing Free Space with Thresholds

Dropping a threshold

Use sp_dropthreshold to remove a free-space threshold from a segment. Its syntax is:

sp_dropthreshold dbame, segname, free_space

The dbname must specify the name of the current database. You must specify both the segment name and the number of free pages, since there can be several thresholds on a particular segment. For example:

sp_dropthreshold mydb, "default", 200




Copyright © 2005. Sybase Inc. All rights reserved. Creating a free-space threshold for the log segment

View this book as PDF