I don't think this is the complete story: if the field is defined NOT NULL then the existing rows WILL get the default value. So the really, the correct answer depends on the SET ANSI_NULL_DFLT_ON or ANSI_NULL_DFLT_OFF setting  (or whatever EXEC sp_dboption does in this respect).