Conference amcucs::ms-sqlsvr

354.0. "Inconsistency with foreign key" by STKHLM::KNORN (I'm still here) Mon Mar 24 1997 08:13

    
    I get the following error when trying to insert a row into
    a table which has two foreign keys defined:
    
    Msg 430, Level 16, State 0
    Unable to resolve table name for object id '313052151', dbid '11' when
    compiling foreign key.
    
    The workaround is to recreate the table and then reload the data.
    
    1. Is there any supported method of resolving the original problem ?
    2. Can this problem be detected by some consistency function/program ?
    
    
    Stefan

    
    I would do a  dbcc checkcatalog   and a  checkdb.  
    
    I haven't tried the checkcatalog to see if really does find
    inconsistency in something like foreign keys.  But it 'should' .  ;-}
    
    Mary Jo