Hi Guys and Girls!
I am setting up a replication solution for a customer, replicating 7 tables, but not all columns in the tables. Publisher and distributor are on SQL 2005 Std, subscriber on SQL 2008 ent.
I have set in the article options for each of the published tables to replicate the clustered index, but not the non clustered ones. All columns involved in the clustered indexes are replicated in all tables.
It works fine on 6 tables, but on the 7:th I get a non clustered index on the subscriber (including the correct columns thou..) instead of the exepected clustered index.
I do not have any errors anywhere, and snapping again does not fix the problem.
Any ideas what might be causing this? And how to fix it?