Results 1 to 2 of 2

Thread: Error 547 urgent

  1. #1
    Balbir Singh Guest

    Error 547 urgent

    I removed the constraint and update the table and after that I enforced the constraint again and got following error.
    I check the data in both table is fine and both the table have a primary key on it.

    Thanks for help in advance

    Server: Msg 547, Level 16, State 1, Line 1
    ALTER TABLE statement conflicted with TABLE FOREIGN KEY constraint 'fk_ikw_indexed_form_approved_ikw_indexed_uri& #39;. The conflict occurred in database 'rns_indexed', table 'ikw_indexed_form_approved'.

  2. #2
    Mohammed. Guest

    Error 547 urgent (reply)



    Hi singh,

    I think it is Bug is Sql 7.0. please check it out in Technet.

    Mohammed.
    ------------
    Balbir Singh at 12/13/00 5:18:57 PM

    I removed the constraint and update the table and after that I enforced the constraint again and got following error.
    I check the data in both table is fine and both the table have a primary key on it.

    Thanks for help in advance

    Server: Msg 547, Level 16, State 1, Line 1
    ALTER TABLE statement conflicted with TABLE FOREIGN KEY constraint 'fk_ikw_indexed_form_approved_ikw_indexed_uri& #39;. The conflict occurred in database 'rns_indexed', table 'ikw_indexed_form_approved'.

Posting Permissions

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