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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-10-14 : 22:23:17
|
| lcooky writes "I have a snapshot replication,for example:the publishing database is testp and the subscribing database is test,how can I get the data that been update on subscribing database? So I write a trigger on subscribing database like that: create trigger trans on table1 for insert,update as insert table2 select * from inserted table1 is the replication table and table2 is a table that it's struture been copied from table1. But the tigger do not work when the replication succeed.Why and How ?" |
|
|
|
|
|
Replication & Trigger