Hi Mohammed ... search for "sql server instead delete trigger".  This returns some very helpful sources.  Be careful with the two magic tables with the unfortunate names "deleted" and "inserted". ...