Sending notifications with change tracking

Question

Hi,

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 ?

Answer 1

Hello,

Please, could you tell us if you are tracking data changes or ddl changes ?

I propose you this link

http://social.msdn.microsoft.com/forums/en-us/sqldatabaseengine/thread/09C6FD31-9B63-4C92-A034-AA5884921FBB

as i am not sure what you want to do

Dont't hesitate to post again for more explanations or help

Have a nice day

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.