Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

how to refresh a table in subscriber Expand / Collapse
Author
Message
Posted Tuesday, December 25, 2012 1:26 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, June 26, 2013 8:47 PM
Points: 18, Visits: 22
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.
Post #1400094
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse