I want to use SQL Server 2005 Notification services in order for an agent of some kind to repeatidly Poll adb in order to identify a change/update to particular tables, and then for an action to take effect?
What the best way to do this? as the novice in me say a windows service sounds perfect? but it then again it sounds like a duplication in technology? Would a website be better? but that said i dont want or need a front end to this so is this better or worse?
Any advice would be much appreciated