Error while opening sales shipment line table

prabhupdesh

On opening sales shipment line table, i get following error:
"[Microsoft][ODBC SQL Server Driver][SQL Server] Attempt ot fetch logical page(3:380765) in database'test-db' belongs to object 'test-company$32$5', not to object 'Acompany$Sales Shipment Line' ".

Please note that I am opening sales shipment line from company 'ACompany' and "test-company" is another company in the same database i.e., 'test-db'. Pls help me in opening this dataase.

kine

It seems like your database is corrupted. May be some HDD fault. Best will be to restore from backup (if you have any). See SQL Event log for more errors...

kriki

[Topic moved from 'NAV/Navision' forum to 'SQL General' forum]

bbrown

Run DBCC CHECKDB to determine the extent of the corruption. If DBCC CHECKDB does not report additional errors then the first object mentioned is corrupt. See "Error 605" for more information.


http://msdn.microsoft.com/en-us/library/aa258728(SQL.80).aspx