title: Delete records within Instead Of Delete trigger
body: <p>I want to have an instead of delete trigger so that I can get text field values out of the table row that's being deleted to preserve those fields when the actual delete occurs. For some reason I can't pull them from the Deleted table in a standard Delete trigger (SQL errors out).</p>
  
  <p>Is there a way to do an actual delete within in an "instead of delete" trigger without making the trigger refire?</p>
  
  <p>Or a better way of getting text fields once a row is deleted to save into a new record?</p>