Cannot insert duplicate key row in object with unique index . The duplicate key value. The statement has been terminated
Solution 1:
Open the Indexes
tree under your table. You will find an Index named 'OSIDX_OSUSR_6SL_RIDER_4NAME'
.
Script out that Index and you will see that it is a UNIQUE index on a "name" column that you are trying to create a duplicate value in.
You must either change that Index to include Route and Bus ID, or you must abandon your attempt to create a new row with a duplicate name.