July 28, 2005 at 11:31 am
From the server side and under connection tab, I saw someone set the query time out = 600. Is this correct that if an query or a sql statement run more than 1' will be time out. Please someone explain this for me. Is it correct that I can increase this number 1000 to fix the problem? Thank so much.
Minh Vu
July 29, 2005 at 8:25 am
Minh Vu - the "600" you see is the default SQL Server setting - it is true that you can increase it to 1000 or even set it zero which would be unlimited wait time...
however, this is a 10 minute wait...quite a long time already - how are you connecting to your database and what is the query that you are using ? Also what error msg do you get ?
if you're using an ACCESS query for example, there's supposed to be an indvidual query timeout setting that you can change...here's the link if this is the case...
**ASCII stupid question, get a stupid ANSI !!!**
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply