Hi Gail,

Thanks for the reply.

I know that the above trigger will fire after insert action to the sometable and insert the records to someothertable.

You used the statement

Select somecolumn from inserted.

What is this inserted? Can i use the sometable inplace of inserted?