troubleshooting Question

Check changes and update MSSQL on remote computer

Avatar of noobe1
noobe1 asked on
Visual Basic.NETMicrosoft SQL Server 2008
2 Comments1 Solution335 ViewsLast Modified:
I have five computers connected to the server. They all have MSSQL 2008. There's only one database and it has 5 tables. The largest has about 1 million rows.

When someone logins from one of the computers and starts my application, I want the application to compare the tables in the local database to the tables located in the server database. If changes are detected, I want the local database updated.

I've thought of using the method suggested on the following page but it could be slow on large tables:
http://stackoverflow.com/questions/36/check-for-changes-to-a-sql-table 

What other options do I have?

Thanks
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros