November 24, 2008 at 8:40 am
hello im gtgn the following error when i update the two columns of the table..the table has 177,000 rows...the column before was varchar(30)..had to make it varchar(10) and the other was similar.
Unable to modify table.
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
please help me..
November 24, 2008 at 8:56 am
Are you using the GUI to change the table, or directly issuing an Alter Table command from Management Studio, or something else?
Also, how big is the table you are altering? Millions of rows? More?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 24, 2008 at 8:57 am
Are you running an update or did you change the table properties in SSMS?
Please give more details about what happened and what you did. Also, how are you making this change and what is your connectivity. A timeout is a timeout.
You can change the data in batches, changing less than 177k at a time, which might help with the timeouts. As far as changing the table's structure, it takes time. Perhaps you can terminal server to the server and make the change there if you have an iffy network connection.
November 24, 2008 at 11:55 am
just had to change the timeout from 30 secs to 120 secs and it worked fine..thank you for your suggestions...
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply