how to refresh a table in a subscriber
-
Tuesday, December 25, 2012 8:31 PMhi
i have two program ([U]App1[/U] And[U] App2[/U]) on two seperate system.on [U]App1[/U] there is a database named [U]DB1[/U] and on [U]App2[/U] there is a database named [U]DB2[/U].on DB1 i create a table named [U]Table_1[/U] .i define replication for DB1 to push publication (for table_1) .i define[U] DB2 [/U]as a subscriber to recive all changes on [U][DB1].[Table_1][/U]. every thing is ok but just one thing. when App1 and App2 both are running if i change the contents of [U][DB1].[Table_1][/U] this change only shown if one time i exit from App2 and rerun it . how can i refresh App2 without rerun it?
a frind said to me it is posible with trigger.but how? i dont know how can i define a trigger for this reason . or any way that exist for this reason.
All Replies
-
Wednesday, December 26, 2012 9:26 AM
how can i refresh App2 without rerun it?
Hello,
You app have to take care on it's own the refresh screen data; that's not done automatically for you. And trigger won't be a solution for this. Instead of, please have a look a MSDN: Working with Query Notifications to see how your app can be notifie, when data changes.
Other option is to poll for data changes.
Olaf Helper
Blog Xing- Edited by Olaf HelperMicrosoft Community Contributor Wednesday, December 26, 2012 9:27 AM
- Proposed As Answer by Allen Li - MSFTModerator Thursday, December 27, 2012 3:14 AM
- Marked As Answer by Allen Li - MSFTModerator Tuesday, January 01, 2013 1:11 AM
-
Wednesday, December 26, 2012 4:27 PMModeratorUse transactional replication or change data capture.
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
.png)
