1
Vote

Delete Root fails in certain cases

description

SQL error text
 
 
(0 row(s) affected)
Msg 547, Level 16, State 0, Procedure boogaloo_core_root_DeleteRoot_sp, Line 37
The DELETE statement conflicted with the REFERENCE constraint "FK_boogaloo_nodecontrol_tbl_boogaloo_node_tbl". The conflict occurred in database "sscr2boogaloo", table "dbo.boogaloo_nodecontrol_tbl", column 'node_id'.
The statement has been terminated.
Msg 547, Level 16, State 0, Procedure boogaloo_core_root_DeleteRoot_sp, Line 39
The DELETE statement conflicted with the REFERENCE constraint "FK_boogaloo_node_tbl_boogaloo_theme_tbl". The conflict occurred in database "sscr2boogaloo", table "dbo.boogaloo_node_tbl", column 'theme_id'.
The statement has been terminated.
 
(0 row(s) affected)
Msg 547, Level 16, State 0, Procedure boogaloo_core_root_DeleteRoot_sp, Line 43
The DELETE statement conflicted with the REFERENCE constraint "FK_boogaloo_node_tbl_boogaloo_mastertemplate_tbl". The conflict occurred in database "sscr2boogaloo", table "dbo.boogaloo_node_tbl", column 'master_template_id'.
The statement has been terminated.
 
(0 row(s) affected)
 
(0 row(s) affected)
 
(0 row(s) affected)
 
(0 row(s) affected)
Msg 547, Level 16, State 0, Procedure boogaloo_core_root_DeleteRoot_sp, Line 59
The DELETE statement conflicted with the REFERENCE constraint "FK_boogaloo_mastertemplate_tbl_boogaloo_root_tbl". The conflict occurred in database "sscr2boogaloo", table "dbo.boogaloo_mastertemplate_tbl", column 'root_id'.
The statement has been terminated.

comments