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 |
|
pug2694328
Posting Yak Master
166 Posts |
 Posted - 2006-06-14 : 15:47:13
|
| Is there a point at which SQL Server will timeout on a query execution? Is there a way to view the current max? Is there a way to reset it? Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-06-14 : 15:50:44
|
| The default timeout is 30 seconds but that is not inside SQL Server. SQL Server will allow you to continue your query indefinitely. You can setup Query Analyzer so that it times out after a certain point though, but the engine will always let you continue processing. So the timeouts are configured in the application and not inside SQL Server.Tara Kizeraka tduggan |
 |
|
|
|
|
|
Maximum query time?