Replication in sql 2000

• bahador.nasiri

  SSC Enthusiast

  Points: 162

  More actions

  December 24, 2012 at 12:33 am

  #266542

  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

• Chris Becker

  SSCrazy

  Points: 2645

  More actions

  December 26, 2012 at 6:12 pm

  #1571721

  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

  Chris Becker bcsdata.net