How do you change the timeout in a stored procedure?

Question

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Russel Loski SSCertifiable Points: 7059 More actions · Answer 1

That is something the client sets. I think that the server has a timeout, but by default it is unlimitted.

What tool are you using? Each one has a different method for changing the timeout.

Russel Loski, MCSD

Russel Loski, MCSE Business Intelligence, Data Platform

Matthew Purtill SSC Veteran Points: 290 More actions · Answer 2

I'm testing it in the Query Analyzer in SQL Server 2000.

Russel Loski SSCertifiable Points: 7059 More actions · Answer 3

That is easy. Click the tools/options menu.

Then go to the Connections tab. I have the "Query Timeout (seconds)" set to "0" which I believe means don't timeout.

Russ

Russel Loski, MCSE Business Intelligence, Data Platform

Matthew Purtill SSC Veteran Points: 290 More actions · Answer 4

SSC Veteran

Points: 290

February 18, 2004 at 7:34 am

Thanks!

bellis SSCarpal Tunnel Points: 4667 More actions · Answer 5

Along the same line, what if you're in EM and you right-click on a table and select Open Table | Query? How do you change the time-out setting here?

noeld SSC Guru Points: 96590 More actions · Answer 6

bellis,

in EM you will set it on the TOOLS(Menue)-->Options-->Advanced(Tab)-->query time-out in seconds:

* Noel

bellis SSCarpal Tunnel Points: 4667 More actions · Answer 7

This is currently set to 0. Isn't this the value to imply "unlimited"?

If so, I still get time-out messages using this method of querying a table. The message...

[Microsoft][ODBC SQL Server Driver] Timeout expired.