| Author |
 Topic  |
|
|
lw1990
Yak Posting Veteran
USA
83 Posts |
 Posted - 01/14/2010 : 12:19:48
|
Hi,
I created a view which has a complicated query (like INNER JOIN, UNION…..) and takes long time to run.
It takes 60 seconds to run in the Query Analyzer (with the same query) to display the result.
But when I run the “Execute SQL” in the view, after 30 seconds, I got this error message:
---------------------------
Microsoft SQL Server Management Studio
---------------------------
SQL Execution Error.
Executed SQL statement: SELECT ...
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.
---------------------------
OK Help
---------------------------
How to set in the SQL Server Management Studio to let the execution time never expired?
Thanks.
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
|
lw1990
Yak Posting Veteran
USA
83 Posts |
Posted - 01/14/2010 : 13:16:16
|
Thank you Tara,
Yes, that what I did to run the query in a new query window and used 60 seconds to finish.
But, my question is how we can set the Management Studio to run the query in the view. I know it is unnecessary to do in this way, but I'm just wondering if there is a way to do this.
Appreciate for your response.
|
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
| |
Topic |
|
Can not execute a view
