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.....
>
--sb--