>Would there be a way to optimize this line which adds a field into a table:
>
>
>ALTER TABLE [MyTable] ADD [MyField] numeric(11,0) DEFAULT 0 WITH VALUES
>
>
>Considering that the table has 1838535 records, this takes between 5 and 10 minutes for each new field. I just had to add 28 fields and this took 4 hours.
Altering many fields in 1 statement might help... only 1 time to read the whole dbTable