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 - 2002-10-07 : 07:50:49
|
Enamoto writes "Hello all,I would like to know how to configure idle connection timeout in SQL Analyzer.Frequently I found many sleeping connections using Analyzer that last batch time are more than 2 hour ago.I'm resolving this problem killing one by one using Enterprise Manager.I need to configure the unused connection time out so this kind of unused connections could automatically be closed.Thanks in advance,Enamoto" |
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-10-07 : 08:14:48
|
Easiest way is to make sure you close the query analyser when you are done.You can easily write a shceduled job to kill off connections that haven't been used - but it might be upsetting if you've spent a long time building up a temp table but have been called away for a time or are waiting for an event to use it.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|