troubleshooting Question

SQL Server 2000 Index Errors with Large database

Avatar of kc5sig
kc5sig asked on
Tax / Financial SoftwareSystem UtilitiesDatabases
8 Comments1 Solution572 ViewsLast Modified:
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\include\record.inl:1447
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'.

ASKER CERTIFIED SOLUTION
JestersGrind

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
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.

-Mike Kapnisakis, Warner Bros