Microsoft KB Archive/899556

= You may experience performance issues when you use SQL Server Distributed Management Objects (SQL-DMO) components in a multithreaded environment =

Article ID: 899556

Article Last Modified on 11/2/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Desktop Engine (Windows)
 * Microsoft SQL Server 2000 Developer Edition
 * Microsoft SQL Server 2000 Enterprise Edition
 * Microsoft SQL Server 2000 Personal Edition
 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft SQL Server 2000 Workgroup Edition
 * Microsoft SQL Server 2000 Developer Edition
 * Microsoft SQL Server 2000 Enterprise Edition 64-bit

-



SYMPTOMS
When you use Microsoft SQL Server Distributed Management Objects (SQL-DMO) components in a multithreaded environment, you may experience access violations, assertions, and memory leak issues.



CAUSE
This issue occurs because SQL-DMO was not designed to be a multithreaded component. SQL-DMO is not thread safe.



MORE INFORMATION
If you must use SQL-DMO in a multithreaded environment, SQL-DMO objects should only be created and be accessed by a single thread.

Keywords: kbbug kbfix kbsqlserv2000presp4fix kbpubtypekc kbmsccsearch KB899556

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.