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 |
|
mikejohnson
Posting Yak Master
153 Posts |
 Posted - 2004-12-13 : 13:32:08
|
| we have a couple processes that run every hour on the hour. they check for certain customers and email them accordingly. We also have an application that accesses data from the same db. sometimes during an hour when the processes run, users get a timeout error. what can i do to solve this? the application is mostly written in asp. processes are dts/jobs |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-12-13 : 14:26:03
|
| SQL Server doesn't timeout the query by default. Timeout values are set at the application level. So you can either increase the value or optimize the code.Tara |
 |
|
|
|
|
|
sql server time out