|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > Timeout Expired
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| I have an application built using VC++ 6.0 that connects
to SQL Server 7.0 on an NT platform.
One of my Database (Corporate) has few tables which has
records in the size 90,000 and some has 49,000 records or
so.
While trying to update one of the column in the table A
(has 70,000 records), I'm facing this 'TIMEOUT expired'
problem. I tried executing that query from the query
manager too, but still I face the same error.
Is this because of the size of the database ?
Are there any parameters that need to be set with some
specific values to overcome this error ?
I would appreciate your help in this regard.
Thanks
Aqua
| |
| Simon Su [MS] 2002-11-30, 1:23 am |
| Hi Aqua,
I guess "query manager" you mentioned refers to Query Analyzer, right? In
Query Analyzer, there is a settings called "query timeout". You can set
this setting to 0 and execute your statement again, see whether it works.
Also please verify you are not running into the following situation,
Q305635 PRB: A Timeout Occurs When a Database Is Automatically Expanding
http://support.microsoft.com/defaul...b;EN-US;Q305635
Please refer to BOL on how to set the "query timeout' in Query Analyzer.
Regards,
Simon Su [MS]
-----------------------------
This posting is provided Ħ°AS ISĦħ with no warranties, and confers no rights
|
|
|
|
|