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 |
|
lcooky
Starting Member
1 Post |
 Posted - 2001-10-10 : 22:42:24
|
| 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 ? |
|
|
|
|
|
Trigger!!!???