Thanks for your efforts Ken but GSquared had already provided me with the answer and it's working perfectly well.

Regards,

Ady

Brilliant! These sort of things demonstrate my lack of depth with SQL Server. Thanks very much for your help - it worked a treat.

Thankfully I don't...

Yeah I thought the same. Here's what I tried:

CREATE TRIGGER Trg_CartwallTitlesIns ON dbo.CartwallTitles

AFTER INSERT AS

DECLARE @rowcount tinyint

SELECT @rowcount...