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 |
|
bh0526
Yak Posting Veteran
71 Posts |
 Posted - 2010-09-21 : 15:51:50
|
| I am trying to run a query that joins together several tables. But I keep getting the "Timeout expired" error. So I clicked, Tools, Options..., Designers and then changed the Transaction time-out after value from 30 seconds to 900 seconds. But I am still getting the error after 30 seconds or so. How come?Bob |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
bh0526
Yak Posting Veteran
71 Posts |
Posted - 2010-09-22 : 07:39:28
|
| Thanks for the reply. I probably should have provided more info. I use this query to run a SQL Server Reporting Services report. The report runs in seconds using this query. The timeout only occurs while I'm in SQL Server Management Studio Express. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
bh0526
Yak Posting Veteran
71 Posts |
Posted - 2010-09-22 : 13:41:09
|
| Tara,I'm not sure what an execution plan is.Bob |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
SQL Timeout error - SQL 2005