I am trying to do transactional replication from a 2000 SP4 server to a 2005 SP2 server. The table involved has a composite primary key composed of three integers and a varchar(50) and I get this message:
"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."
Any idea what could be causing this? Why would it say the table doesn't have a PK when it actually does? Is there some obscure technical detail I am missing?