Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Avoiding timeout on table structure
Message
 
To
25/02/2009 12:41:19
General information
Forum:
Microsoft SQL Server
Category:
Database management
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01384100
Message ID:
01384128
Views:
40
>How can I avoid this message when I try to increase a char field from 60 to 80?
>
>
>'MyTableName' table
>- Unable to modify table.  
>Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
>
There is a setting in SQL Server 2005 Management Studio that may effect this:

Tools - Options - Designers - Table and Database Designers - Override connection string time-out value for table designer updates:

I had this same problems changing some column definitions in a large table, and needed to increase that value to 30.
Chris McCandless
Red Sky Software
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform