SQL Server Timing out 1

[nondrinker]

Hello,

I am trying to increase the field size of column of a table, that has 500,000+ records in it, but the system keeps timing out. I have tried to stop and restart the SQL Server service also, and then tried to make my change but same thing happens.

In the database the connection time property is set to 1200 seconds (20 minutes), but it times out on me in just 2 minutes or so. I am using SQL Server 2005.

Thank you.

 

[mrdenny]

The connection timeout property is for starting a connection to the SQL Server for for running commands.

The GUI times out after ~60 seconds.

You will need to make the change via code.

You can setup the change in the GUI and click the "Generate Change Script" icon (upper left buttons). This will give you a T/SQL script that you can run to make the change.

And no this timeout can't be changed.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[nondrinker]

Thank you,

It worked!

 

[mrdenny]

no problem.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com