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 |
|
tiss0183
Starting Member
18 Posts |
 Posted - 2008-01-22 : 11:35:52
|
| I am getting a timeout error when I try to delete a column from a table w/ about 3 mil records:'Trades' table- Unable to modify table. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.When I go to the server properties, "View connection properties", the "Connection Timeout" propery is set to 15 and "Execution Timeout" is set to 0. However, I cannot change any of the Connections properties; the font is colored gray. I am running SQL Server 2005 on the local computer. Any idea how to change the Timeout property? |
|
|
tiss0183
Starting Member
18 Posts |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-01-22 : 12:10:13
|
| You need to have Sysadmin permission to change Server properties. |
 |
|
|
tiss0183
Starting Member
18 Posts |
Posted - 2008-01-22 : 19:36:29
|
| How do you gain this permission? I searched around and apparently you need to be able to login as "sa". But then it is advised to never use this login. I cannot login with "sa" either way. This aspect of SQL Server is very confusing. Can someone point me in the right direction? There is info overload on this topic on the internet. I am running SQL Server 2005 on the local computer. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-01-22 : 22:46:16
|
| tell your SYSADMIN guy to take care of this issue. |
|
|
|
|
|
|
Timeout setting