>The column had the DEFAULT set before I made the change of the column size. And I do prefer not to change the default. Do I understand correctly that the DEFAULT will stay the way it was before I change the size?
>Thank you.
In earlier versions of SQL Server I always got "Can not ALTER ... there is a constraint' something like this (can't remember the exact text).
That is why I have this habit to remove default constraint, change the size and put the constraint back.
Maybe MS changed this behavior lately and there is no more error, I don't know.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
