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-11-22 : 07:34:09
|
| bk writes "I have several SQL Servers that does not seem to terminate the connection when the user exit or cancel a query. This happens on 3 different SQL Server 7.0 with SP4 on NT4.0. One of the server created over 1k user connections and only one user were testing the app. Need help in figuring out how to prevent all these unneccessary connections and overhead.thanks for the help," |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-11-22 : 08:14:48
|
| The server woun't terminate a connection if the client is still there.Does the app close the connection?If using query analyser the connection will be held after the query is complete or cancelled until the query window is closed.You can kill connections from the server - but make sure they are inactive.==========================================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. |
 |
|
|
|
|
|
sql connection not terminating