Hey can you be more specific about your question? i am not able to get it.

Thanks guys for your help. I have figured it out. The trigger works like a charm. Thanks to Andy for giving me the proper clues.

hey Andy, could you please write the SQL statement based on my example. I did try yours, but i am getting errors. Please help me out.

To both. It seems if you have SQL 7.0 already running on your server, you can buy an upgrade license for SQL 2000 based on per processor plan and still...

Not anymore. I think they prefer if you use the per processor license for the current and the future.

Thanks Steve for your prompt response,

Thanks Andy and Sean, the trigger worked like a charm !

hey andy, does this mean that inorder for me to update table A, i have to create another table "inserted B" ? is there no other work around to this...