Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Replication in sql 2000 Expand / Collapse
Author
Message
Posted Monday, December 24, 2012 12:33 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 14, 2014 4:56 AM
Points: 5, Visits: 37
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
Posted Wednesday, December 26, 2012 6:12 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, November 23, 2014 9:55 PM
Points: 222, Visits: 249

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 »

Add to briefcase

Permissions Expand / Collapse