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


The information in this article applies to:

  • Microsoft SQL Server 2000 Desktop Engine (MSDE)
  • 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 64 bit
  • 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.
Modification Type:MajorLast Reviewed:5/18/2005
Keywords:kbSQLServ2000preSP4fix kbfix kbbug kbmsccsearch kbpubtypekc KB899556 kbAudDeveloper kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.