A while ago I wrote an article about database unit testing, and the various ways you could "rollback" the database state to the way it was before the test ran.
Today I got an interesting comment from Mike Brockey:
"I have yet another solution to this very common problem. We have been able to isolate the steps for preparing a database snapshot, tracking the database modifications and then refreshing the modified tables back to their original state all using built in SQL statements. We call it dataFresh and it is available now from our website as part of our TDD Developer's Toolkit, all free of charge.
http://blogs.ent0.com/blogs/datafresh/default.aspx"
the downloads section on the site is over here. I haven't tried it yet, but it looks interesting. Thanks Mike!