Hello Steve,
As I understand, you have three application clients running on three
different physical locations, they're use the same SQL Server database.
When one client update the data in the database, you want the other two
clients to display the new data.
Before we go any further, would you please tell me which SQL Server version
do you use?
Anyway, you can try the Query Notifications in SQL Server, it is used for
applications that need to refresh displays or caches in response to changes
in underlying data. For more information about Query Notifications, you can
refer to these documents:
Query Notifications in SQL Server (ADO.NET)
http://msdn.microsoft.com/en-us/library/t9x04ed2.aspx
Working with Query Notifications
http://msdn.microsoft.com/en-us/library/ms130764.aspx
Using Query Notifications in .NET 2.0 to handle ad-hoc data refreshes
http://www.codeproject.com/KB/databa...fications.aspx
If you have any questions or concerns, please feel free to let me know.
Sincerely,
Zhi-Xin Ye
Microsoft Managed Newsgroup Support Team
Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can
improve the support we provide to you. Please feel free to let my manager
know what you think of the level
of service provided. You can send feedback directly to my manager at:
ms****@microsoft.com.
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/en-us/subs...#notifications.
Note: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the
community or a Microsoft Support Engineer within 2 business day is
acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need
further investigation to reach the most efficient resolution. The offering
is not appropriate for situations
that require urgent, real-time or phone-based interactions. Issues of this
nature are best handled working
with a dedicated Microsoft Support Engineer by contacting Microsoft
Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subs.../aa948874.aspx
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.