I am getting an error message when I try to add a column to a table(I am adding the new column in the middle of an already exist sequence of column order). The table has almost 40million rows.
Error Source: mscorlib The Error Message: Exception of the type 'System.OutOfMemoryException' was thrown
and another error message -'Unable to modify table. Timeout expired.The timeout period elapsed prior to completion of the operation
Please, I will appreciate if there is a workaround adding a column to an existing able with so much data and the added column can be added to any position in the sequence order of columns and not at the end of columns list.
I will appreciate if someone can help with this.
asked Nov 13 at 08:22 PM in Default