Monitoring a database
-
Hello, I want to create a windows service application that listen to changes in a SQL server database then sends all these changes to an other server waiting for the server response. Can i use the sql service notification service to restart the windows service after each change in the database and how? or there is adicect solution fron the database itself? Thanks for advance.
Dad
-
Hello, I want to create a windows service application that listen to changes in a SQL server database then sends all these changes to an other server waiting for the server response. Can i use the sql service notification service to restart the windows service after each change in the database and how? or there is adicect solution fron the database itself? Thanks for advance.
Dad
If you are talking about server replication, that is built in, and you should use the built in system. If you are wanting another program to do certain things when certain things happen, you should have those 2 apps talk to each other and not have one constantly look at the database.
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo