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

SQL Replication p2p 2012 Ttable "KEY IDENITY's" Expand / Collapse
Author
Message
Posted Thursday, June 26, 2014 4:55 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: 2 days ago @ 11:33 AM
Points: 6, Visits: 67
I have 3 servers P2P replication

I know I have to change the "KEY IDENTITY" on all the tables

Right now the table "KEY IDENTITY" is (1,1)

I want server one to be "KEY IDENTITY" is (1,3)
I want server two to be "KEY IDENTITY" is (2,3)
I want server three to be "KEY IDENTITY" is (3,3)

What is the best way I can change the tables in the servers



Post #1586680
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse