We help IT Professionals succeed at work.

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

244 Views
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.

thanks,
newbieweb
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2008
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
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.

OR

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.