Re: timeout expired on View

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi, everybody
I have the same problem I'm running SSMS with MS SQL Server 2005. When I try
to open view from SSMS interface, from local server (left mouse button on the
viewOpen view) it shows me “Executing Query” and after 30 seconds write such
error:
“Error Source: .Net SqlClient Data Provider.
Error Message: Timeout expired. The timeout period elapsed prior to
completion of the operation or the server is not responding. ”
When I try execute only select from this view it tooks me about 1min 20 sec
and its allright-I see the results.
I resolved this problem locally when I changed in registry “SQLQueryTimeout”
(HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
Server\90\Tools\Shell\DataProject\SQLQueryTimeout) from 30 sec. to 600 on
Server, but only locally now from SSMS I can run Open view and see the
execution result. When I run this procedure from remote PC (client) SSMS I
see the same problem
(“Error Source: .Net SqlClient Data Provider. Error Message: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding. ”)

Also when I try to run this view from remote PC from MS Access it shows me
such error: “ODBC-call failed [Microsoft][ODBC SQL Server Driver]Timeout
expired (#0)”

I can’t find any solution.
What shell I do? Any suggestions?


"Mark Han[MSFT]" wrote:

Hi Ed,

Thank you for the update. I'm glad that my point 2 is helpful. Since we can
run the query(select into) in Query window to work around the issue, could
you please tell me your concern on the work around?

Besides, based on my experience, the issue might be by-design. The query
can always run successfully in Query window ,but in the View Design mode,
timeout expired might happen. The difference with the 2 scenario is the
platform the qurey run; and the 2 mode is designed; it is not allowed to
change them.

Hope the above helpful. Thanks.

Best regards,
Mark Han
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@xxxxxxxxxxxxxx
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================


.

Quantcast