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 |
|
sqldba20
Posting Yak Master
183 Posts |
 Posted - 2007-09-20 : 13:53:04
|
| Folks:Need to know whether there is a timeout configuration in SQL 2000? Some of my processes get blocked and they will wait for hours (7 to 8 hours) for the other process to get completed. I would like them to time-out if the process is blocked for lets say more than 10 mins....Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-09-20 : 14:06:10
|
| No such config option exists inside SQL Server. This config is at your client, typically can done in the connection string or app.config.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
sqldba20
Posting Yak Master
183 Posts |
Posted - 2007-09-20 : 14:16:04
|
| IS 'SET LOCK_TIMEOUT' set at the individual stored procedure level or at the server level? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-09-20 : 14:22:02
|
| BOL has the answer.Not sure why you'd want to use that setting for your problem though.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Time-Out