Hello.
I'm trying to set-up transactional replication between 2 servers. I've followed the wizard to replicate the table, am warned only tables with primary keys can be published in transactional replication, only to to find the 'specify articles' menu does not allow selection of tables with primary keys!
On other databases merge replication is already running fine, so doubtless there's something fundamental I'm missing in this instance.
Any suggestions gratefully received.
Incidentally, I have looked at the relevant titled Tek Tips SQL Server articles with 'replication' in the title, as well as conducting wider internet searches and have'nt found anything.
I'm trying to set-up transactional replication between 2 servers. I've followed the wizard to replicate the table, am warned only tables with primary keys can be published in transactional replication, only to to find the 'specify articles' menu does not allow selection of tables with primary keys!
On other databases merge replication is already running fine, so doubtless there's something fundamental I'm missing in this instance.
Any suggestions gratefully received.
Incidentally, I have looked at the relevant titled Tek Tips SQL Server articles with 'replication' in the title, as well as conducting wider internet searches and have'nt found anything.