Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Adding new column to a huge table

Author  Topic 

srivatsahg
Yak Posting Veteran

71 Posts

Posted - 2009-08-11 : 04:23:03
Hello

I have a huge table (approx 4,000,000 records)
Now i want to add a new column to this table.
I get query timeout if i use it from the UI wizard.

Any suggestions of adding a new column to this table..

Srivatsa

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-08-11 : 04:35:12
Cross post
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=130972



N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page

srivatsahg
Yak Posting Veteran

71 Posts

Posted - 2009-08-11 : 04:40:50
Thanks Peso
It helped.
I generated a change script on table Modify and used in the query window




quote:
Originally posted by Peso

Cross post
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=130972



N 56°04'39.26"
E 12°55'05.63"


Go to Top of Page
   

- Advertisement -