I am using Visual Studio 2008 to play with some data in some large tables. The tables have already been filled with several million records.
But, now I want to add new fields to the table. When I try and add a new field using the data table view in Visual Studio 2008, I get a timeout that says "'EOD' table - Unable to modify table. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."
How do I increase the timeout so that I can add new fields to the tables?