February 17, 2004 at 8:29 am
I have a stored procedure which is hitting the 30-second timeout limit. How can I change it in the stored procedure so that it doesn't timeout?
Thanks,
Matt
February 17, 2004 at 11:41 am
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
February 17, 2004 at 12:09 pm
I'm testing it in the Query Analyzer in SQL Server 2000.
February 17, 2004 at 1:27 pm
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
February 18, 2004 at 7:34 am
Thanks!
February 18, 2004 at 7:53 am
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?
February 18, 2004 at 8:00 am
bellis,
in EM you will set it on the TOOLS(Menue)-->Options-->Advanced(Tab)-->query time-out in seconds:
* Noel
February 18, 2004 at 8:07 am
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.
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy