We help IT Professionals succeed at work.

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

Last Modified: 2013-12-17
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.

Watch Question

Most Valuable Expert 2012
Top Expert 2008
This one is on us!
(Get your first solution completely free - no credit card required)
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.