InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 13:02:58 GMT20http://www.sqlservercentral.com/Forums/Topic1412046-391-1.aspxThanks opc.three I got if fixed thanks to you.LonMon, 28 Jan 2013 09:48:51 GMTlonhannerhttp://www.sqlservercentral.com/Forums/Topic1412046-391-1.aspxYou have some orphaned data that you'll need to cleanup before adding the constraint.[code="sql"]SELECT RIDER_NOFROM TRIP_DETAILSWHERE RIDER_NO NOT IN (SELECT RIDER_NO FROM RIDERS);[/code]Or you can do this incrementally by adding the constraint WITH NOCHECK to in effect prevent the creation of new orphaned rows but tolerate the existing orphans, then cleaning up the bad data as time allows, and finally once all orphans are removed or resolved going back and CHECKing the constraint:[code="sql"]-- 1. add constraint but do not check existing rowsALTER TABLE TRIP_DETAILS [b]WITH NOCHECK[/b]ADD CONSTRAINT fk_TRIP_DETAILS_RIDER_NOFOREIGN KEY (RIDER_NO)REFERENCES RIDERS(RIDER_NO);-- 2. cleanup orphans as time allows...-- 3. check the constraint to let the database engine record that it can rely on the existing data conforming to the constraintALTER TABLE TRIP_DETAILS CHECK CONSTRAINT fk_TRIP_DETAILS_RIDER_NO;[/code]Sat, 26 Jan 2013 12:26:25 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1412046-391-1.aspxThere's a RiderNo in trip details that does not have a matching entry in RidersSat, 26 Jan 2013 10:43:55 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1412046-391-1.aspxI receive the following error when trying to set FKThe ALTER TABLE statement conflicted with the FOREIGN KEY constraint "fk_TRIP_DETAILS_RIDER_NO". The conflict occurred in database "DCTSSQL ", table "dbo.RIDERS", column 'RIDER_NO'.ALTER TABLE TRIP_DETAILSADD CONSTRAINT fk_TRIP_DETAILS_RIDER_NOFOREIGN KEY (RIDER_NO)REFERENCES RIDERS(RIDER_NO);Sat, 26 Jan 2013 10:18:46 GMTlonhanner