i have two program (App1 And App2) on two seperate system.on App1 there is a database named DB1 and on App2 there is a database named DB2.on DB1 i create a table named Table_1 .i define replication for DB1 to push publication (for table_1) .i define DB2 as a subscriber to recive all changes on [DB1].[Table_1]. every thing is ok but just one thing. when App1 and App2 both are running if i change the contents of [DB1].[Table_1] 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.