Primary Key on Replication

[nikhilparchure]

hi Guys ,
Just need to know if a primary key is mandatory on a table while setting up replication defination for a table.
Help appreciated
Thanks in advance

Regards
Parchure Nikhil

 

[clapag22]

It is required for Transactional Replication. I assume it's the same for all replication types.

 

[royjimenez]

it's required and u will need a global unique identifier.

What kind of replication are u talking about ?





The life is too short to cry and long enough to try it... God bless us.

 

[clapag22]

You don't need an GUID for transactional replication.