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 |
|
indersshekhawat
Starting Member
26 Posts |
 Posted - 2011-11-21 : 00:36:39
|
| i am replicating a part of table(few column ) from database a to b table. i not require trigger which is in publisher because trigger is updating column which i not have in subscription database. when i enter data directly entered in subscription i require trigger only link to subscription database may it is possible to maintain different trigger for sub database |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-11-21 : 16:29:49
|
| sure. drop the trigger at the subscriber. |
 |
|
|
indersshekhawat
Starting Member
26 Posts |
Posted - 2011-11-25 : 04:15:47
|
| but sir i want trigger at subscriber . subscriber trigger have some different statement from publication trigger. because some column in trigger's tables are different in publication and subscriber. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-11-30 : 13:37:50
|
| Oh, I misunderstood. No reason that you can't have different triggers at the subscriber. |
|
|
|
|
|
|
how to maintain diff trigger in pub. and subs.