Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Replication and Triggers

Author  Topic 

purisqlserver
Yak Posting Veteran

73 Posts

Posted - 2002-07-12 : 06:21:44
Hi,

I am using transactional replication from db1 from server1 to db2 on server2. I trying to use triggers on db2(server2) to update the data another database db3(server3), when replication takes place between server1 and server2. The update trigger on the table in db2, is not triggered on replication. How to know, when the data is updated on db2 ????

Thanx in advance.

M.E.
Aged Yak Warrior

539 Posts

Posted - 2002-07-12 : 13:59:22
What type of replication? I do believe bulk inserts do not start triggers

-----------------------
Take my advice, I dare ya
Go to Top of Page

purisqlserver
Yak Posting Veteran

73 Posts

Posted - 2002-07-16 : 02:10:09
I am using transactional replication, is there way to detect replication and carry on the process of updating the data on other database. suggestions are welcome.

Go to Top of Page
   

- Advertisement -