Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
lw1990
Yak Posting Veteran
85 Posts |
Posted - 2010-01-14 : 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 ProviderError 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
38200 Posts |
|
lw1990
Yak Posting Veteran
85 Posts |
Posted - 2010-01-14 : 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 |
|
|
|
|