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 |
|
pamyral_279
Posting Yak Master
143 Posts |
 Posted - 2007-01-17 : 01:52:44
|
| I open enterprise manager , right click and choose detach detach database.I see line : connections using this database.I think that this is connection from client connect to database.I feel that connectiondisappear automatically after time interval.I want to know how long time ?Thank you very much. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-01-17 : 02:01:57
|
| Connections don't disappear automatically. They are either disconnected by the client or they are killed by a sysadmin.Tara Kizer |
 |
|
|
pamyral_279
Posting Yak Master
143 Posts |
Posted - 2007-01-17 : 03:42:17
|
quote:
Originally posted by tkizer
Connections don't disappear automatically. They are either disconnected by the client or they are killed by a sysadmin.Tara Kizer
I write web application using .Net sql client data provider.When i open my web app,hit database.Number connection increase,if i close my web app then number connection decrease.But i have a question :How to database know when client disconnect ???Thank you very much. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-01-17 : 13:00:44
|
| It receives the disconnect from the client, so that's how it knows. The information is sent to SQL Server.Tara Kizer |
|
|
|
|
|
|
Connection in detach database.