<div>
You need to set the timeout on the command object to something quite high. The default is only 30 seconnds: <a href="http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.commandtimeout.aspx" rel="ugc">http://msdn.microsoft.com/<wbr />en-us/libr<wbr />ary/system<wbr />.data.sqlc<wbr />lient.sqlc<wbr />ommand.com<wbr />mandtimeou<wbr />t.aspx</a>
</div>


<div>
I'm not using a command object. &nbsp;I am using the database designer in VS 2008 to add a field to the table.<br />
<br />
That's where the timeout is coming from.
</div>


<div>
Here is the highlighted field I am trying to add....<br />
<br />
&nbsp;<a href="https://filedb.experts-exchange.com/incoming/2011/05_w20/459232/trying-to-add-this-field.JPG" target="_blank" title="field to be added (97 KB)"><img alt="field to be added" class="file-block lazyload" style="max-width: 703px;" data-src="https://filedb.experts-exchange.com/incoming/2011/05_w20/459232/trying-to-add-this-field.JPG" /></a><br />
<br />
And here is the first error that I get when I click to save the altered table.....<br />
<br />
&nbsp;<a href="https://filedb.experts-exchange.com/incoming/2011/05_w20/459233/Error-1.JPG" target="_blank" title="error 1 (38 KB)"><img alt="error 1" class="file-block lazyload" style="max-width: 575px;" data-src="https://filedb.experts-exchange.com/incoming/2011/05_w20/459233/Error-1.JPG" /></a><br />
The full text of the error is...<br />
<br />

<blockquote>
/*<br />
&nbsp; &nbsp;Saturday, May 14, 20119:08:00 AM<br />
&nbsp; &nbsp;User: <br />
&nbsp; &nbsp;Server: CERKSEES-PC\SQLEXPRESS<br />
&nbsp; &nbsp;Database: EOD<br />
&nbsp; &nbsp;Application: <br />
*/<br />
<br />
'EOD' table<br />
- Saving Definition Changes to tables with large amounts of data could take a considerable amount of time. While changes are being saved, table data will not be accessible.
</blockquote>
<br />
Then I get a second error screen...<br />
<br />
&nbsp;<a href="https://filedb.experts-exchange.com/incoming/2011/05_w20/459234/error-2.JPG" target="_blank" title="error 2 (34 KB)"><img alt="error 2" class="file-block lazyload" style="max-width: 569px;" data-src="https://filedb.experts-exchange.com/incoming/2011/05_w20/459234/error-2.JPG" /></a><br />
And it's text error message is...<br />
<br />

<blockquote>
/*<br />
&nbsp; &nbsp;Saturday, May 14, 20118:45:42 AM<br />
&nbsp; &nbsp;User: <br />
&nbsp; &nbsp;Server: CERKSEES-PC\SQLEXPRESS<br />
&nbsp; &nbsp;Database: EOD<br />
&nbsp; &nbsp;Application: <br />
*/<br />
<br />
'EOD' table<br />
- Unable to modify table. &nbsp;<br />
Timeout expired. &nbsp;The timeout period elapsed prior to completion of the operation or the server is not responding.
</blockquote>
</div>


trying-to-add-this-field.JPG

Error-1.JPG

error-2.JPG

ee-changetimeoutvs.PNG

<div>
Perfect!! &nbsp;<br />
<br />
Thanks for your help!
</div>


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


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?

How to fix Timeout on SqlExpress database from Visual Studio 2008?

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.