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 |
|
angeloo
Starting Member
1 Post |
 Posted - 2012-11-01 : 11:49:34
|
Hi DBA´s, I need help with issue of transactional replication,this issues is , when i want to create a transactional replication at time of select the articles to publicate, in the botton of the wizard appear a message that say, This table cannot be published because it does not have a primary key column. Primary key columns are required for all tables in transactional publications.Someone to help fix this issue.Thank for you help.  |
|
|
prett
Posting Yak Master
212 Posts |
Posted - 2012-11-05 : 22:52:13
|
| In transactional replication, it need a primary key for each table to replicate. It is a way to uniquely identify each row of a replicated table, so that, when changes to a row are replicated to the subscribers, there's no doubt as to which row the change must be applied.Snapshot replication, since it just copies tables as they appeared at a specific point, does not have this requirement. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2012-11-16 : 22:51:48
|
| Primary Key is important in Database world. |
|
|
|
peterdixon410
Starting Member
5 Posts |
Posted - 2014-08-29 : 07:51:43
|
| Yes, I am SQL server 2012 user and I have used SQL server repair & recovery software for corruption and deletion of MDF files, the software provide you three scanning mode facility to repair and Recovery Toolbox for SQL Server. Visit and read this : http://www.sql.recoverytoolbox.com/[url][/url] |
|
|
|
|
|
|
|
|
Replication issue