I have enabled change tracking on several tables. Right now I am using VBA to check for changes every two seconds. I was thinking that there might be a smarter way of doing this, like for example MS SQL sending a message when something is changed and VBA
listening for changes ? Is that possible and if yes how ?