Thx Sergey,

I was looking at using the 'INSTEAD OF' trigger but this in an AFTER is simpler. The only thing that threw me for a while was that the trigger fired when there was nothing to insert (ie INSERT INTO ...... (SELECT ......) caused the trigger to fire even if the select returned no records - that didn't seem very logical to me?

Regards,
Viv


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