title: How can I fire a trigger BEFORE a delete in T-SQL 2005?
body: <p>How can I fire a trigger BEFORE a delete in T-SQL 2005?
  The FOR actually fires AFTER an event and they seems no BEFORE argument in the TRIGGER function.
  The INSTEAD OF is not what I want. 
  I need to fire before I delete a record.
  Any ideas?</p>