benharel
asked on
SQL Delete error in Dotnetnuke
critical error has occurred.
The DELETE statement conflicted with the REFERENCE constraint "FK_BK_StaffDirectory_Pers onTitle_BK _StaffDire ctory_Pers on". The conflict occurred in database "USR_BrooksKushman-DNN", table "dbo.BK_StaffDirectory_Per sonTitle", column 'PersonId'. The statement has been terminated.
The DELETE statement conflicted with the REFERENCE constraint "FK_BK_StaffDirectory_Pers
Looks like what's happening is that you're trying to delete a row that has a key on it that other tables reference. My guess is that it's your StaffDirectory table. Delete the data out of there for your desired dataset first and then out of the BK_Staff_Directory_Persona l_Title table
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.