?
Solved

SQL Timeout period expired adding column to table

Posted on 2007-10-15
3
Medium Priority
?
2,060 Views
Last Modified: 2008-03-26
I am trying to add a column to an existing (very large) table.  I am doing this in SQL SERVER MANAGEMENT STUDIO.  I get the following message:

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

How can I extend the timeout so this can complete???  I would like to do this in Management Studio if I can.

0
Comment
Question by:MGothelf
3 Comments
 
LVL 16

Expert Comment

by:SQL_SERVER_DBA
ID: 20079115
0
 
LVL 5

Expert Comment

by:R_Hos
ID: 20079135
If your database is getting a lot of activity (via web server or the like) the table modification is going wait for those to run.  You can take your database offline (stopping all of those connection) and then restart it.  That should give you a few seconds to run your modification script.

~R
0
 

Accepted Solution

by:
MGothelf earned 0 total points
ID: 21157919
No solution was provided.  
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

615 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question