Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > SQL Language
|
SQL Language SQL Language discussions not specific to a particular RDBMS program or vendor.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Language section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 4th, 2004, 05:17 PM
Registered User
 
Join Date: Sep 2004
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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.





Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL Server Naming convention for Replication darrenb SQL Server 2005 3 May 3rd, 2008 02:50 PM
triggers in replication melvik SQL Server 2000 3 July 11th, 2007 01:44 AM
SQL Server Transactional Replication with Triggers RRNP SQL Language 0 October 4th, 2004 05:18 PM
Replication and Triggers comibnation RRNP SQL Server 2000 2 September 27th, 2004 08:23 AM
MS SQL Server Replication rodmcleay SQL Server 2000 2 August 12th, 2004 02:33 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.