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 2005 Forums
 Replication (2005)
 Transaction Replication

Author  Topic 

kumarich1
Yak Posting Veteran

99 Posts

Posted - 2008-12-17 : 10:38:17
I have set up transaction replication between two servers. For some reason I was thinking that if I set up transaction replication one additional column will be added to each table, but I don't see any additional columns added to the tables after setting up transaction replication. Can anyone please confirm this, so I will be sure that what I am doing is correct.

Thanks in advance

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-12-17 : 10:41:57
It happens only with Merge Replication or Transaction Replication with updated/Queued Subscriptions. Guid column is for trigger purposes for two-way replication.
Go to Top of Page

kumarich1
Yak Posting Veteran

99 Posts

Posted - 2008-12-17 : 10:44:24
quote:
Originally posted by sodeep

It happens only with Merge Replication or Transaction Replication with updated/Queued Subscriptions. Guid column is for trigger purposes for two-way replication.



Thanks so much
Go to Top of Page
   

- Advertisement -