Michael Maddison
michael at ddisolutions.com.au
Fri Jun 17 00:59:48 CDT 2011
Anyone been here? My scenario... 3rd party software sends and receives SMS msgs. 3rd party db with a Message table. I use the app API to send a text message. This ends up in a Message table. I want to monitor without polling the StatusID field for obvious reasons. I've looked at MSMQ, Service Broker and SQLDependency. AFAIKT only SQLDependency offers an event raised when the data is updated. Just to complicate things the field I'm interested in is updated, each row numerous times per second! 99.99% of the time the statement is Update StateID = 2 .... Where StateID = 2 .... I'm guessing rather than poll and makes updates they just update in a loop... Any suggestions welcome. Cheers Michael M