Msg 547, Level 16, State 0, Line 54
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_RoutetoCarrier". The conflict occurred in database "master", table "dbo.Carrier", column 'CarrierID'.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 56
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_RoutetoCarrier". The conflict occurred in database "master", table "dbo.Carrier", column 'CarrierID'.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 58
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_RoutetoCarrier". The conflict occurred in database "master", table "dbo.Carrier", column 'CarrierID'.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 60
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_RoutetoCarrier". The conflict occurred in database "master", table "dbo.Carrier", column 'CarrierID'.
The statement has been terminated.
Msg 50000, Level 16, State 1, Procedure Valid_Route_ID, Line 16
Route ID is not valid
Msg 3609, Level 16, State 1, Line 63
The transaction ended in the trigger. The batch has been aborted.