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.
| Author |
Topic |
|
dr223
Constraint Violating Yak Guru
444 Posts |
 Posted - 2009-10-26 : 06:15:32
|
| hallo, I have a table which I try to change a field from nvarchar(50) to nvarchar(20). The table is built of 118,000,000 records. When it is in the process of saving a pop up appears saying;'o_pat1'table- Unable to modify table.Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.Please could anyone help me how I can remove the timeout.Checked;Tool - Option - Query Exceution - Exceution time-out - 0 seconds. |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-10-26 : 06:22:20
|
| Run the ALTER table command in QA.For long-running operations it's better to use a script. |
 |
|
|
dr223
Constraint Violating Yak Guru
444 Posts |
Posted - 2009-10-26 : 06:30:18
|
| Please could you show me the syntax, is this correctAlter Table dbo.o_pat1Alter Column o_prac_uid NVARCHAR (20) |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-10-26 : 09:59:55
|
| yes |
|
|
|
|
|
|
Timeout expired Problem