Learn how to add transaction support to your database unit tests in Team Edition for Database Professionals in order to better manage the database state during your test run.
http://channel9.msdn.com/ShowPost.aspx?PostID=244523
Sachin Rekhi