>Specifically what I am trying to do is in the delete trigger of a
>particular table copy some of the data to another table for archiving

Does it work using something like this:

INSERT INTO save_table (col1, col2)
SELECT column1, column1 FROM deleted

-Mike