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 |
|
ccopinc
Starting Member
4 Posts |
 Posted - 2008-02-27 : 08:53:07
|
| We have a table with 3.5 million records in it. We have been forced to add two fields and set indexes on those fields. But when we try to save the changes it times out. When we try to generate a change script it also times out. Is this a memeory issue? Any ideas on whats causing this or how to fix it woudl be greatly appriciated. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-02-27 : 09:28:20
|
| I am guessing that you are running this from your workstation rather than remoting onto the server and running it there?If so, then either remote onto the server or change the remote query timeout (s) in sp_configure. |
 |
|
|
ccopinc
Starting Member
4 Posts |
Posted - 2008-02-27 : 09:31:03
|
| we have tried it both from workstations and remoting in. however I did not know about changing the remote query timeout... I will check into that more. ty |
|
|
|
ccopinc
Starting Member
4 Posts |
Posted - 2008-02-27 : 09:32:49
|
| ok I have never used sp_configure... any help? |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-02-27 : 09:46:58
|
| sp_configure 'show advanced options',1gothen run:recongigure with overridegoThen run sp_configure again and you will see the option.You will need to set 'allow updates' to 1 in the same way first. |
|
|
|
|
|
|
Saving changes