SQL Server Transactional Replication with Triggers
Actually my requirement is like this.
I need pull the differential data(Transactions occured on the publication
database during the day) from the subscriber database and write to the file
or anothr table which is not the part of replication.
So for this I have created the transactional replication between the
publisher and subscriber.Then I have altered the articles in the subscriber
with the time stamp column and I have written a trigger on the subscriber to
update the time stamp column with the current date, whenever the insert or
update happens to the subscriber.
Triggers are not complex just it is a one line(update tablename set
lastupdate=getdate()).
The only issue here is this working fine for small voulme of data.But for
the large volume of data I am getting the time out expire at SQL agent.
|