FIX: Statement in the PollStatement property incorrectly runs if a receive location uses WCF-based BizTalk Adapter for SQL Server

Symptoms

Consider the following scenario:

• You have a computer that is running Microsoft BizTalk Server 2006 R2, Microsoft BizTalk Server 2009 or Microsoft BizTalk Server 2010.

• You create a receive location that uses a Windows Communication Foundation (WCF) LOB Adapter SDK-based SQL adapter to receive messages in a Microsoft SQL Server database.
  
  For example, you use a custom adapter that has the sqlBinding binding type selected, or you use WCF-based BizTalk Adapter for SQL Server from Microsoft BizTalk Adapter Pack 2.0 or BizTalk Adapter Pack 2010.

• You specify a statement in the PolledDataAvailableStatement property to return a non-positive value.

In this scenario, a statement that is specified in the PollStatement property may incorrectly run.

Resolution

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References

For more information about how to receive polling-based data changed messages from SQL Server by using the WCF channel model, visit the following MSDN website:

How to receive polling-based data changed messages from SQL Server by using the WCF channel model For more information about BizTalk Server hotfixes, click the following article number to view the article in the Microsoft Knowledge Base:

2003907 Information on BizTalk Server hotfixes