Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 942978 - Last Review: December 3, 2007 - Revision: 1.1
The SqlDependency object cannot distinguish between messages that are intended for different client processes in the .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 "Applies to" section.
APPLIES TO
- Microsoft .NET Framework 2.0
| kbtshoot kbprb kbexpertiseadvanced KB942978 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
Be the first to leave feedback, to help others about this knowledge base
article.
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please