Microsoft KB Archive/942978

= The SqlDependency object cannot distinguish between messages that are intended for different client processes in the .NET Framework 2.0 =

Article ID: 942978

Article Last Modified on 12/3/2007

-

APPLIES TO


 * Microsoft .NET Framework 2.0

-



SYMPTOMS
In the Microsoft .NET Framework 2.0, the SqlDependency object represents a query notification dependency between an application and an instance of Microsoft SQL Server 2005. If you use the SqlDependency object to retrieve messages from a queue, the SqlDependency object cannot distinguish between messages that are intended for different client processes. Therefore, if two processes are using the SqlDependency object on the same queue, the process that receives the notification may not be the process that requests the notification. In this case, some events cannot be used correctly.



WORKAROUND
To work around this problem, use one of the following methods:
 * Use manual methods. When you do this, you can make sure that only one process uses the SqlDependency object on a queue.
 * Create a separate queue in each process.

Note To use this method, the process must have elevated permissions. The process identity must have the CREATE QUEUE permission.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

Keywords: kbtshoot kbprb kbexpertiseadvanced KB942978

-

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

© Microsoft Corporation. All rights reserved.