|
Hi,
I have one
application written in C#.Net. In this We have one windows Services which
will be running in a server. This windows service will get the records from
a table in sql server 2000, and it will call the appropriate
exe's. The backend database is present in the other
server. Now the problem is when some records
are added/deleted or updated in a Table, the Windows service should be
alarmed about it, so that it can again fetch the new records
from the same table. My requirement is both the table and the windows service
has to be synchronized immediately. I tried using watching the File
with a File watcher in the windows service, and the File will be
modified from the Backend using the Extended Stored
Proc sp_makewebtask. But this will work when both the Windows
service and the Sql server is present in the same system.
The file watcher or the SP makewebtask cannot access the file which is present
in the other system.
What will be a alternative for this problem or is
there any better solution for this to happen.
Any Ideas how can we synchronies the windows
service and the Backend database table (immediately after a DML
operation).
Regards,
Krishnan
SPONSORED LINKS
YAHOO! GROUPS LINKS
|
