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 - 2004-03-10 : 08:33:45
|
| Nambirajan writes "SQL Server : MSDE OS : Win 2000 Service Pack 3We have a COBOL application talking to SQL Server.The application creates connections with SQL Server. If the connection goes down abnormally( due to network failure etc), the connection becomes orphan. This orphan connection is getting cleared in 4 minutes time.I like to know where this 4 minutes timing is set?I tried the following references. None of them helpedINF: How to Troubleshoot Orphaned Connections in SQL Serverhttp://support.microsoft.com/?id=137983TCP/IP and NBT Configuration Parameters for Windows 2000 or Windows NT http://support.microsoft.com/?id=120642Tuning NWLINK Registry Parameters http://support.microsoft.com/?id=99745" |
|
|
|
|
|
How orphan connections are getting cleared?