Data Replication one way event to fire procedure
-
Tuesday, December 04, 2012 10:56 AM
Hello,
We have Database on live server and we are using replication (one-way) to fetch the database on local server.
We need do some modification as we want to update the Users table Password on local server only.
How can we achieve this?
Is there any event when we can fire the procedure on Users table?
Could you please suggest the ways to do this?
Regards
Ashish
All Replies
-
Tuesday, December 04, 2012 5:10 PMModerator
Do you want an event to fire when a change (DML) is made on the subscription database by replication and only by replication?
If this is the case you can use the session property - when sessionproperty('replication_agent') evaluates to 1 the change on the subcriber will be caused by a replication process.
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
-
Wednesday, December 05, 2012 5:02 AM
I want to immediately fire my update command(to update user table) on my local copy of Database after replication complete from Source database to local.
.png)
