Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dbuser123
Starting Member
20 Posts |
 Posted - 2006-02-17 : 08:43:47
|
| I have multiple tables in a database. Many tables with identities.Let us say i have 2 sql servers at 2 sites. I want to replicate the data on thse 2 sites to a 3rd sql server.The problem im having is that one of the tables has a set of 10 rows which are standard across all sites. They are created as soon as the table is created. For other rows i can always setup identity ranges for different sites and take care of conflicts. How do i handle this ??My boss is breathing down my neck to get this resolved :(Any help is appreciated.. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-02-17 : 10:19:56
|
| Set a filter on your replication to ignore these 10 rows, you can then just insert them yourself on the 3rd server and not worry about them again.. (unless you need to re-initialise your subscriptions, in which case it's best to have a script handy).. |
 |
|
|
|
|
|
SQL Identity Replication