Replication in sql 2000

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Replication in sql 2000

Replication in sql 2000

Rate Topic

Display Mode

Topic Options

Author

Message

bahador.nasiri

Posted Monday, December 24, 2012 12:33 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, January 15, 2013 9:48 PM
Points: 5, Visits: 26

Hi Guys

Whereas I did not find my problem here, I am posting the new one.
Actually I set up a transactional replication on sql 2000 and it works properly except keys are not created on subscriber!

Thanks in advance

Post #1399830

Chris Becker

Posted Wednesday, December 26, 2012 6:12 PM

SSC Veteran

Group: General Forum Members
Last Login: Friday, February 22, 2013 11:49 AM
Points: 220, Visits: 216

What keys? PK/FK? Look at properties of any article in gui.

If you are sure this is set properly, make sure there is no other table on subscriber with same constraint name, e.g. cannot have > 1 pk w/ same name... this bit me before.

Hope this helps & Regards,
Chris
mssqlconsulting.com

Post #1400425

« Prev Topic | Next Topic »

Permissions