Hello everyone.

Did anyone faced this problem? What could be causing it?
When I run this query in a query analyzer for the table with many records:
ALTER TABLE mytable ADD mynewid int NOT NULL DEFAULT(0) WITH VALUES

new field mynewid is created, but records are populated with random number instead of 0.

That table does not have any Trigger on it.
Field name could have any name.
DBCC CHECKTABLE and DBCC CHECKDB did not show any errors.

Thanks, Paul.