Is it possible to make a call/notification to a C++ application from Microsoft SQL Server?
To give a broader understanding of what I'm trying to achieve: our database is being updated with new information; Whenever a new piece of information is received, we'd like to push this to the C++ application so that its dashboard reflects up-to-date data for the user.
We know we can do this by having the C++ application polling the database but I see this as inefficient architecture and would like to have SQL push the information or a notification to C++.
Any light shed on this area is greatly appreciated!
----- 28th Jan 3:40pm ----
OK After some reading around on Service Broker External Activation it seems like the right technology to use; however it seems to technology that's introduced in SQL Server 2008; and unfortunately we're using SQL Server 2005. Are there any other suggestive technologies or architectural designs we could use?