Another good free alternative could be 'Mercury' which is the complementary Mail Transport for the email client 'Pegasus Mail'. See http://www.pmail.com/.

While I haven't used it in anger myself I did...

Here is an inelegant but straight forward way we use of creating a quick backup of a table in the same database:

select *

into [backup_table_name]

from [source_table_name]

Might not be a good method...