Use a transaction.
>>Hi Naomi,
>>
>>I think that you should not write to the production DB, even if you are Rolling back, you should do your tests on a test database.
>
>Surely we don't write to production database. But I don't want to add them even to the test database we're using.
>
>And actually, the production database is something installed at the client. Each of the developers have their own local installation + we have several common databases for tests.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer