Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. redrovercmc

    How do I correct Disconnected Overflow Pages in SQL 6.5

    I have been getting these page corrections reported in my weekly DBCC scripts for months. Any more help you can give?
  2. redrovercmc

    How do I correct Disconnected Overflow Pages in SQL 6.5

    The entry in sysobjects with an ID = 8 is the syslogs table. This is different from the table reported with a disconnected overflow page. The DBCC did not report a disconnected overflow page this week. Is this an indication that it was an eronious error before? Do you have any advice on...
  3. redrovercmc

    How do I correct Disconnected Overflow Pages in SQL 6.5

    My DBCC CHECKDB is giving the following message. I can't tell which table it relates to, so I don't know if it is for the same table. Checking 8 The total number of data pages in this table is 5388. The number of data pages in Sysindexes for this table was 71029. It has been corrected to...
  4. redrovercmc

    How do I correct Disconnected Overflow Pages in SQL 6.5

    The DBCC Showcontig output is below. Does this help in solving the cause/resolution? Could this be an eronious error from running DBCC while changes are being made to the data? DBCC SHOWCONTIG scanning 'block' table... DBCC execution completed. If DBCC printed error messages, see your System...
  5. redrovercmc

    How do I correct Disconnected Overflow Pages in SQL 6.5

    I am using Microsoft SQL 6.5, SP 5a. When I run DBCC SHOWCONTIG one of my tables gives ... - Disconnected Overflow Pages..................: 1 - Avg. Bytes free per Disconnected Ovfl page...: 1911.8 - Avg. Disconnected Overflow Page...

Part and Inventory Search

Back
Top