SQL Server Performance

how to refresh a table in subscriber

Discussion in 'ALL SQL SERVER QUESTIONS' started by pooya, Dec 25, 2012.

  1. pooya New Member

    hi
    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.
  2. Shehap MVP, MCTS, MCITP SQL Server

    First Welcome to forums ..

    I can see this case is irrelevant to SQL Server Replication coz it sounds like an issue to enforce refreshment on the page but to verify that more , you can open replication monitor from SQL Server Management studio and inset a trace token at the relevant replication to determine how much replication latency is exists then you can identify explicitly the reasons of this data delay either replication latency or a Page refreshment..

    Please let me know if any further help is needed
  3. pooya New Member

    thanks about your attention ....

Share This Page