asked on

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

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?

brutaldev

You need to set the timeout on the command object to something quite high. The default is only 30 seconnds: http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.commandtimeout.aspx

cerksees

ASKER

I'm not using a command object. I am using the database designer in VS 2008 to add a field to the table.

That's where the timeout is coming from.

cerksees

ASKER

Here is the highlighted field I am trying to add....

And here is the first error that I get when I click to save the altered table.....

The full text of the error is...

/*
Saturday, May 14, 20119:08:00 AM
User:
Server: CERKSEES-PC\SQLEXPRESS
Database: EOD
Application:
*/

'EOD' table
- 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.

Then I get a second error screen...

And it's text error message is...

/*
Saturday, May 14, 20118:45:42 AM
User:
Server: CERKSEES-PC\SQLEXPRESS
Database: EOD
Application:
*/

'EOD' table
- Unable to modify table.
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

ASKER CERTIFIED SOLUTION

brutaldev

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

cerksees

ASKER

Perfect!!

Thanks for your help!