We have been having problems with the next page and previous page linkage on one of our database`s. For some reason we get lost chains of pages. (It is SQLServer 4.21a and we are migrating to SQLServer 6.5 soon).

The question is does anyone know how to zap the page numbers in the links so that the links are actually pointing at the correct pages. By dumping the pages out using DBCC PAGE, and displaying the links using DBCC PKLINKAGE we can see where the pages should be, but how do you fix them.

For example page string 1000 - 1200 are contiguous, then page string 1201 through 1225 are contiguous. The problem is that page 1200 points at 1226 and page 1225 points at 1226, and 1226 reverse points at 1200. If we could zap the pointers on 1200 to point at 1201, and 1226 to reverse point at 1225, all would be well.

Any ideas?

Keith