On Aug 12, 10:29*am, "Martin Arvidsson, Visual Systems AB"
<martin.arvids...@vsab.netwrote:
Hi!
Sorry if I am posting this in the wrong NG.
What I want to do is to create a .NET dll that alerts my program when an
update has been commited to a specific table in my SQL Database.
Is it possible? Any directions on what to google on, links etc?
Any help would be most kindly...
Apart of SQLDependency as Kalpesh mention I do not know of any other
way. You can always poll it.
We have a software that does something like that. When new data
becomes available it update a counter in a system table, and there is
a service process that holds a reference to the last checked value, if
the value in the DB is bigger, then it goes and refresh the data.
In another escenario there is a table that holds jobs references, and
there are several processes (again windows services) that are the
executers, in this case each row has a flag to indicate if the process
is being (or was) ran. and again a poll mechanism is used.