We created various databases on various servers. These databases all have to replicate with a central database and we set up a Merge replication process for it.
We just discovered that the databases should have been created with the Primary Keys (Identity) Option set to NOT FOR REPLICATION.
Is there a way to create a query to change all the ID columns in all the tables and run the script, or is this a manual process of having to change these Identity columns (the long way)?
Any help with this will be appreciated.
Rgds
Len
We just discovered that the databases should have been created with the Primary Keys (Identity) Option set to NOT FOR REPLICATION.
Is there a way to create a query to change all the ID columns in all the tables and run the script, or is this a manual process of having to change these Identity columns (the long way)?
Any help with this will be appreciated.
Rgds
Len