MS Sql replication - Primary keys problem

[Yordan Yordanov]

Hi.
I am trying to replicate an MS SQL server but when I do that all my primary keys on the tables on subscriber server are gone and the datebase is unusefull.
Can anyone help me in that situation?

Thanks in advance.

[davef]

Hi.
I am trying to replicate an MS SQL server but when I do that all my primary keys on the tables on subscriber server are gone and the datebase is unusefull.
Can anyone help me in that situation?

Thanks in advance.

Set "Copy unique key constraints" property of the articles on the publisher to True if you're on SQL Server 2005.