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 2008 Forums
 SQL Server Administration (2008)
 Question on Transaction replication

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
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -