You can use Raiserror to cancel INSERT

RAISERROR ('Ivalid value for ''ColumnsID'' column', 16, 1)

>
>Considered that too. But, as I understand it, the Insert has already occurred when the trigger fires so I'm not sure what best to put in the trigger.....
>