troubleshooting Question
SQL Server 2000 Index Errors with Large database
We have a 20 Gb database for MS Great Plains Dynamics that is having problems. Of the 1505 tables, 4 are having issues:
SYSINDEXES
TW01155
TW02255
TW00157
When we try to drop tthe table we get the following message:
Location: p:\sql\ntdbms\storeng\drs\
Expression: m_SizeRec > 0 && m_SizeRec <= MAXDATAROW
SPID: 60
Process ID: 844
Msg 3624, Level 20, State 1, Line 1
An update statement gives the following error:
Msg 605, Level 21, State 1, Line 1
Attempt to fetch logical page (1:1144240) in database 'ETEST' belongs to object 'TW00157', not to object 'TW01155'.
SYSINDEXES
TW01155
TW02255
TW00157
When we try to drop tthe table we get the following message:
Location: p:\sql\ntdbms\storeng\drs\
Expression: m_SizeRec > 0 && m_SizeRec <= MAXDATAROW
SPID: 60
Process ID: 844
Msg 3624, Level 20, State 1, Line 1
An update statement gives the following error:
Msg 605, Level 21, State 1, Line 1
Attempt to fetch logical page (1:1144240) in database 'ETEST' belongs to object 'TW00157', not to object 'TW01155'.
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.