>Table re-creation is necessary in some cases.
>
>The fundamental problem is that the scripts builded by SSMS
>are not contained in a single transaction,
>with a rollback when it fail..
>
>When they fails, a part of the transaction remains in the database.
I understand that, but we are both using SSMS and for me it works. So, I am still searching what setting I have that makes it I am not affected when removing a field and he is.