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 |
|
future_is_me
Starting Member
14 Posts |
 Posted - 2013-02-05 : 15:41:45
|
| Hello,I am using SQL Server 2008 R2 SP1 SE. I have a question on transaction replication.In transaction replication is there a way that I can restrict the updates specific only to a column? Lets say if updates occur on source table(publisher database) on column a, column b and column c then I dont want any thing to get updated in the destination database tables (subscriber database). But if update occurs only on column d on source table(publisher database) then I want it to get updated in destination table too (subscriber database). Is this possible?Thanks |
|
|
srimami
Posting Yak Master
160 Posts |
Posted - 2013-02-05 : 22:34:30
|
| Yes it is possible using triggers |
 |
|
|
future_is_me
Starting Member
14 Posts |
Posted - 2013-02-06 : 09:37:01
|
| Thanks. I am not good at TSQL. Please let me know if there is a script available for this.Thanks |
|
|
|
|
|
|
Question on Transaction replication