General information
Forum:
Microsoft SQL Server
Title:
ALTER TABLE mytable ADD mynewid int NOT NULL DEFAULT(0) WITH
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only