Subject How to test a sequence then rollback?
Author Mark Patterson

I want to test a sequence of scripts, adding fields, giving them values and so,
and then roll back, so that I can test the scripts until they all work, and then
use them in earnest on the production database. I do
Transcation.StartTransaction, call all the scritps and then Transcation.Rollback.

But at first I was getting errors trying to put values into the new field. Then
I put CommitRetaining, but that means that the field is still there after the
rollback. What's the trick?