All geek questions in one place

Can you make a C ++ application call from MS SQL Server?

Is it possible to make a call / notification for a C ++ application from Microsoft SQL Server?

To give a more complete picture of what I'm trying to achieve: our database is updated with new information; Whenever a new piece of information is received, we would like to click this on the C ++ application so that its toolbar displays the updated data for the user.

We know that this can be done if a C ++ application polls the database, but I see it as an inefficient architecture and would like SQL to push information or notification in C ++.

Any light sheds in this area are very appreciated!

----- January 28, 15:40 ----

OK After some reading around Service Broker's external activation, this seems like the right technology to use; however, this is similar to the technology introduced in SQL Server 2008; and unfortunately, we are using SQL Server 2005. Are there any other thought-provoking technologies or architectural projects that we could use?

+3
source share
3 answers

You might want to use Service Broker and process the events that it queues. Here's MSDN: http://msdn.microsoft.com/en-us/sqlserver/cc511479.aspx

+3
source

, , , , - . ( )

+1

xp_cmdshell. , , , - SQL sysadmin. , sysadmin, xp_cmdshell. , ...

0

Source: https://habr.com/ru/post/1730302/

More articles:


All Articles