>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