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'.
Our community of experts have been thoroughly vetted for their expertise and industry experience.