>>>UPDATE: I found the answer to this question.
>>
>>:)
>>
>>BTW, this may be helpful for newbies:
>>http://blogs.lessthandot.com/index.php/DataMgmt/DBProgramming/MSSQLServer/best-practice-coding-sql-server-triggers
>
>Thank you. I will read the blog. Although I am overwhelmed with the 1000+ book on SQL Server I am using as I am trying to write my first trigger. Actually I have a question on it but I will start a new thread.

Go ahead and ask here. That blog is quite short and it warns you againt a common mistake many newbies make - create trigger as one row operations.