Hi Roy,

on Trigger
( best is INSTEAD INSERT,
but it have a bug for SCOPE_IDENTITY(), it return NULL)

....
-- suppose my_Incr>0
INSERT ..... (....
, ISNULL((SELECT MAX(myIdentity) FROM thisTable)+my_Incr,my_Seed)
,....

For not slow down the insert, add a index unique for myIdentity.