Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
how to set SQLServer CommandTimeout in SQLAnalysiserver?
0 views
Skip to first unread message
J
Nov 11, 2002, 11:37:03 AM11/11/02
to
When it try to load the RecordCount,an "Command time out!" occured.
I can't find the command timeout setting in the Management Console.
I'm new in SQLAnalysis
Thanks
John
2002/11/11
bhanoji malla
Nov 11, 2002, 2:49:12 PM11/11/02
to
In analysis server management console, right click on the server and go to
properties. Click on processing tab. Server time out option is there.
properties. Click on processing tab. Server time out option is there.
Do you have the latest service pack?
"J" <buch...@bigfoot.com> wrote in message
news:#Y8QpBaiCHA.2340@tkmsftngp08...
microsoft
Nov 17, 2002, 3:49:23 AM11/17/02
to
When you use the ide within sqlserver, either from right clicking on a table
or within vb's ide to sql, you'll get the timeout. The answer is to
originate the query within query analyzer typing it by hand, or, originate
the query within dts. However, within dts, you cannot use the ide within the
query object to run the query. You can use it, but you can't run the query
within the ide. Back out of the object, and run the query at the main dts
screen for that dts. If you don't know how to write the query directly, then
use the ide to build the query, click the sql button, copy the code to
clipboard, open query analyzer, then paste and run.
The user interface says to put zero for timeout, but that is ignored, and
always defaults to 30 seconds. Within vb, you get around the timeout with
ADO by setting the connection object's timeout = 0.
or within vb's ide to sql, you'll get the timeout. The answer is to
originate the query within query analyzer typing it by hand, or, originate
the query within dts. However, within dts, you cannot use the ide within the
query object to run the query. You can use it, but you can't run the query
within the ide. Back out of the object, and run the query at the main dts
screen for that dts. If you don't know how to write the query directly, then
use the ide to build the query, click the sql button, copy the code to
clipboard, open query analyzer, then paste and run.
The user interface says to put zero for timeout, but that is ignored, and
always defaults to 30 seconds. Within vb, you get around the timeout with
ADO by setting the connection object's timeout = 0.
Ran smack-dab in the face of this one 3 years ago trying to relate two 40
million record tables....
Russ Marano
REM Software, Inc.
"J" <buch...@bigfoot.com> wrote in message
news:#Y8QpBaiCHA.2340@tkmsftngp08...
0 new messages