1
vote
0answers
133 views

Identity Range Management problem

Recently upgraded from SQL Server 2000 to 2008. When we recreated the Merge Replication we decided to use Automatic Identity Range Management (since it is now the default in 2008). The problem is ...
1
vote
1answer
251 views

SQL Server 2008 Chaining Merge Replication

Is there a way to have multiple "tiers" for a merge replication in SQL Server 2008. For example I have SiteA with SQL Server 2008 that has a publication setup on TestDB. SiteB, also with SQL Server ...
1
vote
1answer
346 views

Trouble with Identity Range Sizes

I am trying to setup our replication with a republisher. We, unfortunately, have some tables with an int PK IDENTITY and I am getting the following error when trying to create the publication. SQL ...
1
vote
0answers
537 views

Web sync merge replication cannot connect to publisher

Before I start I would like to clarify that I am setting up a test environment to configure & test WebSync before carrying out a deployment at a client. My machines are all running SQL Server ...
0
votes
1answer
207 views

Adding FK Index to existing table in Merge Replication Topology

I have a table that has grown quite large that we are replicating to about 120 subscribers. A FK on that table does not have an index and when I ran an Execution Plan on a query that was causing ...
6
votes
2answers
363 views

Data from a table in 1 DB needed for filter in different DB

I have a Win Form, Data Entry, application that uses 4 seperate Data Bases. This is an occasionally connected app that uses Merge Replication (SQL 2005) to stay in Sync. This is working just fine. ...
3
votes
1answer
496 views

Alter Stored Procedure in SQL Replication

How do I, properly, ALTER a StoredProcedure in a SQL 2005 Merge Replication? I just need to add a Column. I already successfully added it to the Table and I now need to add it to a SP. I did so ...
4
votes
2answers
398 views

Will this force a reinitialize in Merge Replication Topology?

I need to add a couple of columns to a table that is a part of a replication set. It is not a constraint coulumn or a part of any article filters and it allows NULL. I have a pretty good idea that I ...
3
votes
1answer
1k views

Replication sync failing; Publisher out of Identity ranges

I have Merge Replication set up with a SQL 2005 Publisher/Distributor and roughly 100 SQL 2005 Express Subscribers. Everything was working fine for months and now all of a sudden everyone is getting ...
2
votes
1answer
215 views

SQL Merge Replication - Filter Sets

I have a "working" Replication Set in SQL 2005 that we use in house to our users at remote branches on SQL Express 2005. I want to apply a filter to our biggest Set to help minimize the bandwidth ...
1
vote
1answer
56 views

Filtering Replication Sets for Top 2

I have a Replication Set that we use in Merge Replication(SQL 2005). I am trying to figure out how to apply a Filter of Top 2 to a table. Also, is there a way to set up a Filter so that it trickles ...
0
votes
3answers
568 views

SQL Merge Replication - Compress Snapshot

I have Merge Replication set up at our company with a central SQL 2005 as the Publisher/Distributor and the clients are all SQL 2005 Express. In our remote branches we are having difficulty with ...
1
vote
1answer
522 views

Merge Replication Publishing Subscriber Scenario

I have a merge publishing subscriber topology of SQL 2008 -> SQL 2000 -> MS Access 2003. In one database at the SQL 2008 level, I have an updateable publication (called catalog) that is unfiltered, ...
1
vote
3answers
2k views

SQL INSERT INTO vs SELECT INTO vs BCP in a Replication Topology(Stage Environment)

I would like to add the information from my Production DB to my Stage DB. I have a BAK of the Production DB and could just restore from that on Stage but I am concerned of the impact Merge Replication ...