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
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/saFolB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
