SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL Analyzer unused connections		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

AskSQLTeam
Ask SQLTeam Question

USA
0 Posts
Posted - 10/07/2002 :  07:50:49  Show Profile  Visit AskSQLTeam's Homepage  Reply with Quote
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

United Kingdom
12543 Posts
Posted - 10/07/2002 :  08:14:48  Show Profile  Visit nr's Homepage  Reply with Quote
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.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000