Msg 15103, Level 16, State 1, Procedure sp_bindefault, Line 178 Cannot bind a default to a column created with or altered to have a default value.The command that raises this error looks like this:
CREATE TABLE ... [column1] [smallint] NOT NULL CONSTRAINT [DF_tablename_column1] DEFAULT ((0)), ...The script doesn't contain any other constraint with the same name or sets a second default value for this column. I even get this error when I change the command to allow NULL values and remove the constraint.
CREATE TABLE ... [column1] [smallint] NULL, ...
Very very strange things happen here ;-)