Article ID: 317748 - View products that this article applies to.
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:
(http://support.microsoft.com/kb/290211/EN-US/ )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:
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:
119591Microsoft 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.
(http://support.microsoft.com/kb/119591/EN-US/ )How to Obtain Microsoft Support Files from Online Services
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:
(http://support.microsoft.com/kb/316333/EN-US/ )INF: SQL Server 2000 Security Update for Service Pack 2
For more information on the Microsoft Security Bulletins discussed above, please see the following Microsoft Web sites:
Microsoft Security Bulletin MS02-039
Microsoft Security Bulletin MS02-043
Microsoft Security Bulletin MS02-056
Microsoft Security Bulletin MS02-061
To work around this problem, use the following methods:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was first corrected in Microsoft SQL Server 2000 Service Pack 3.
Steps to Reproduce the Behavior