Link to home
Start Free TrialLog in
Avatar of curiouswebster
curiouswebsterFlag for United States of America

asked on

Need to write a process (Windows program?) to poll SQL Server database every 5 seconds

I have access to a database which I can not make any changes to but need to get updates every 5 seconds to 7 diferent tables. I can not create stored procedure or triggers since the development organization has not time to test any change to te database. They have offered me read-only access to the 7 tables I need and will permit me to run a process on their Windows 2000 machine, where the databae resides.

I would like to write a "robot" which will check the database and update my database, on a remote machine, anytime a new record shows up in any of the seven tables.

What's the easiest way to do this?  It could be a C# Windows program so that I can provide a status widow, etc.  Or it could be a database program, I suppose.

Any suggestions?

The OS is Windows 2000 and the database is the SQL version before SQL Server 2005.

thanks,
newbieweb
ASKER CERTIFIED SOLUTION
Avatar of Bob Learned
Bob Learned
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial