This article was previously published under Q317748
When a service or an application quickly and repeatedly connects to and disconnects from a local Microsoft SQL Server 2000 database, a handle leak may occur in the SQL Server process.
These leaks only occur in the SQL Server 2000 Service Pack 2 (SP2) version of the shared memory network library (Dbmslpcn.dll version 2000.80.534.0).
The handle leaks occur in two locations. The handle leak occurs in the first location because of a missing DeleteCriticalSection function call when a connection is closed. The handle leak occurs in the second location because of event handles that are created repeatedly during the connection process.
To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
If you are unable to install the latest service pack, the following fix is available from the Microsoft Download Center: Q317748.exe
Release Date: OCT-30-2002
For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:
119591 How to Obtain Microsoft Support Files from Online Services
Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file. NOTE: The security patches described in Microsoft Security Bulletins MS02-039, MS02-043, MS02-056 and the original release of the security patch described in MS02-061 (released on October 16, 2002) do not contain the Q317748.exe patch discussed in this knowledge base article. This patch was subsequently discovered to be required to ensure normal operation of SQL Server.
If you have applied any of these security patches and decide to apply the patch from this Knowledge Base article you must answer "no" if prompted to overwrite files to ensure that you do not overwrite files from the security patch.
The re-released security patch for Microsoft Security Bulletin MS02-061 (released on January 26, 2003) includes this fix, and if you have installed this re-released patch, no action is required. The re-released patch is available from the following article in the Microsoft Knowledge Base:
316333 INF: SQL Server 2000 Security Update for Service Pack 2