Results 1 to 10 of 10
  1. #1
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665

    Unanswered: odd Indexing errors

    I have been getting odd errors concerning indexes. When im trying to insert into a table it will post an error
    index number_____ belongs to table x not table y
    this error causes a failure in processing the code. If I go to the table in enterprise manager and open it and then close it, it seems to reassociate the indexes with the table and then there are no problems. Does anyone know why the indexes are getting confused?
    Jim

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Did you DBCC CHECKTABLE?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Feb 2002
    Posts
    2,232
    Or dbcc dbreindex.

  4. #4
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665
    Originally posted by rnealejr
    Or dbcc dbreindex.
    Any idea why the indexes are getting corrupted?
    Jim

  5. #5
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    Can you post your insert statements and some DDL?
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

  6. #6
    Join Date
    Sep 2003
    Posts
    522
    is this the message you're getting?

    Attempt to fetch logical page %S_PGID in database '%.*ls' belongs to object '%.*ls', not to object '%.*ls'.

  7. #7
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665
    Originally posted by ms_sql_dba
    is this the message you're getting?

    Attempt to fetch logical page %S_PGID in database '%.*ls' belongs to object '%.*ls', not to object '%.*ls'.
    yes that is exactly the mesg
    Jim

  8. #8
    Join Date
    Feb 2002
    Posts
    2,232
    I don't know if you read this post from microsoft:

    link

    Also, I would run some hardware diagnostics on your hard disks.

  9. #9
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665
    Originally posted by rnealejr
    I don't know if you read this post from microsoft:

    link

    Also, I would run some hardware diagnostics on your hard disks.
    I have 1.3 terabites of disk space....what diagnostics would you recomend?
    Jim

  10. #10
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665
    Originally posted by rnealejr
    I don't know if you read this post from microsoft:

    link

    Also, I would run some hardware diagnostics on your hard disks.
    DBCC CHECKDB ('maersk data warehouse') returned no errors....maybe i have write caching on...thats the only other thing that I can think of.
    Jim

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •