Error while opening sales shipment line table

prabhupdesh
prabhupdesh Member Posts: 49
edited 2009-04-10 in SQL General
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.

Comments

  • kine
    kine Member Posts: 12,562
    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...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • kriki
    kriki Member, Moderator Posts: 9,121
    [Topic moved from 'NAV/Navision' forum to 'SQL General' forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • bbrown
    bbrown Member Posts: 3,268
    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
    There are no bugs - only undocumented features.

Categories