Recent content by dting2

I'm trying to install a Win95/WinNT 4.0 application on a Win2K Pro system. During the installation, Setup gives me an error message saying that the program "Requires Service Pack 3 or above" in order to run -- I assume it is talking about Win NT 4.0 SP3. Unfortunately, the company...

Thanks Paul! In retrospect, I realize I was looking up the alloc page# instead of the extent# -- so no wonder the pagelinks were pointing me to the allocation table! I really appreciate your time in looking into this. I'll definitely be contacting MS Support at this point. Cheers, David

By the way, does anyone know if the undocumented procedure: sp_fixindex as described in http://support.microsoft.com/support/kb/articles/Q106/1/22.asp?LN=EN-US&SD=gn&FR=0&qry=dbcc&rnk=6&src=DHCS_MSPSS_gn_SRCH&SPR=SQL is the repair solution I should use? Thanks, David

I've finally gotten a chance to check some pagelinks. When I run dbcc pglinkage (7, 318976,10,2,0,1), I get the following result: Object ID for pages in this chain = 99. Page : 318976 Page : 3 pprevpg pointer for page 3 does not point to previous page in chain as scanned. pprevpg pointer =...

Wow, thanks for the great explanation. I'll try that procedure and let you know what comes up... David

Thanks, Paul. To answer your first question, yes, I did run DBCC NEWALLOC in single-user mode. (Prior to doing that, I got a TON of spurrious error messages.) Now, before I try the dbcc pglinkage trick, could you explain how I will be able to tell if the pointers are good or bad...

When I execute DBCC NEWALLOC on a large (1.5 GB) database, I get an ERROR 2541 message as follows: Msg 2541, Level 16, State 1 Table Corrupt: object id does not match between extent in allocation page and Sysindexes; check the following extent: alloc pg#=318976 extent#=319088 object id on...