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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-12-09 : 07:20:29
|
| Jazzy writes "Hi I have written a query on the view of SQL server 2005 SEPT CTP. The query has a number of joins to tables in the database. Everytime I execute the view I get a TIMEOUT message . How do i increase the timeout period from the view to help run the queryAny help will be much appreciated.Many thanksJ" |
|
|
druer
Constraint Violating Yak Guru
314 Posts |
Posted - 2005-12-09 : 13:23:45
|
| You can check out SET LOCK_TIMEOUT in books on line. The default should be no timeout which you can check by selecting @@lock_timeout.Have you reviewed the execution plan for the query behind the view to see if it can be enhanced so it doesn't take so long? |
 |
|
|
|
|
|
SQL SERVER 2005: VIEWS TIMEOUT