Consider the following scenario:
- You have Microsoft SQL Server 2008 R2 installed.
- You register query notification with join on the table.
- You delete rows from the tables.
The issue occurs because of a defect in SQL Server 2008 R2.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.