• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2088
  • Last Modified:

SQL Timeout period expired adding column to table

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
MGothelf
Asked:
MGothelf
1 Solution
 
SQL_SERVER_DBACommented:
0
 
R_HosCommented:
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
 
MGothelfAuthor Commented:
No solution was provided.  
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now