Exploring other approaches
Our solution is not perfect as it sits and for all the advantages that SQL notifications can give us, they have several specific drawbacks. One of the largest drawback is that we will never receive notifications for which the location was disabled. This is a problem because we could potentially miss these important notifications. There are two ways we can approach this problem and one is provided by the adapter itself.
Querying for missed notifications
Recall that when we created the notification schema we briefly mentioned the startup event that can be sent by the adapter. This event is intended to inform us that a location has just started and we're ready to receive events on it. The implication is that because the location ...
Get Microsoft BizTalk Server 2010 Patterns now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
