Tuesday, December 04, 2012 10:56 AM
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?
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.