>>At least make sure to make a script for the changes. I think SSMS will do the change using temp table.
>
>How do you do 'script for the change' if all I want to do is change the column type?
In the designer there is a button to script the changes.
If it's not broken, fix it until it is.
My Blog 
