title: trigger for before delete a record
body: <p>I'm using sql server 2005 and have 2 tables in my database.
  How can I write a trigger that can INSERT a record into table 2 BEFORE delete in table 1? 
  How can I do this?
  I need this for VB.Net.
  I've already done a connection with Sql server.</p>