Post reply

when FK relation disabled, still getting FK relation error

  • August 13, 2008 at 3:49 am

    #70983

    Hi

    i have an sp which deletes records from few tables.

    Im observing a weird behaviour -

    I have disabled the FK relation -> then delete records -> enable relation.

    Still sometime i get FK relation error and sometime i dont get it at all and execution is completed successfully.

    What can cause this and how can I rectify it

  • August 14, 2008 at 6:08 am

    #857977

    Are you sure the FK is disabled? Please post some code.

    Could there be another FK on the table?

  • August 14, 2008 at 6:33 am

    #857992

    ALTER TABLE Tbl_ServTime NOCHECK CONSTRAINT FK_Tbl__ServTime_Tbl_xyz

    there are no other FK on this table

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply