Does anyone have a white paper, or case study regarding the use of or implementation of Merge Replication in an SQL Server 2000 environment? My company would like to research using this feature of SQL Server 2000 Tim...more >>

I´m trying to deploy a set of SQL servers which will act as publishers/suscriptors. First, I´d like to perform a test and show the results to my boss. The first problem I have is the following: When I try to configure one of the servers as the publisher, by running the wizard I get the follo...more >>

Should you backup the distribution database? If yes how often? Thank You, Mike...more >>

I currently have one server acting as a publisher and distributor. Merge replication is setup where our shoppes replicate their sales data to the central server once a week. The home office would like to run consolidated sales reports on the data. My thought is to keep them off the publis...more >>

I am using SQL merge replication to synchronize data between offline = client database and central database server. On client machine MSDE and = on server MS SQL Server 2000 is being used. Data transfer is = bi-directional. Replication is done over the ftp. As ftp is non-secured, = synchronizati...more >>

I set up merge replication with pub and distr on the same server. The snapshot agent fails with the following message (from Server Agent job history): "CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID 55. Most significant primary key is 'type 24, len 16'. The step...more >>

I have that has SQL Server 2000 SP 3A with transactional replication. The replication is one-way with two servers. I have received several errors cannot insert duplicate key row in a primary key field. The only way this could in my system would be communication link failure. In this c...more >>

Hi all After reading several documents I think I've an idea of what should I do. I have 2 Web Servers with Windows 2003 and 2 SQL Servers 2000 (4 servers total). I would like to set them up like this: the 2 web servers working together and handling HTTP requests from clients at the same time and 1 ...more >>

We have a problem that has eluded us for quite some time, and finding a solution has become a great priority. Can anyone share their wisdom on this situation?: SQL Server Merge replication. The database has many tables, like, in terms of hundreds. There are a handful of our programming objects...more >>

HI, I have configured merge replication with pull subscription on sql server2000 and subscribers running personall sql server 2000. Subscribers connect through VPN. The application written in VB6 was working properly since 4 months with minor replication problems. A few days ago we rebuilt the pub...more >>

Hi all, I've 2 servers with 2 db that must have the same data... I'm studing how to make replication, but is very difficult for a novice. The connection between the servers is 24h. There some good book with samples step by step (for dummies)? thanks for any idea -- dipic...more >>

Hi I've been running Merge replication successfully now for about 6 months. We use Pull subscriptions and Dynamic Snapshots with FTP over telephone lines. Recently, we upgraded our software that runs on the database, resulting in 2 new tables added to the published article list.I added these t...more >>

Hello, We are in the beginning stages of planning an infrastructure to support a sports app that will allow customers to receive scores, stats, in-game updates as real time as possible(e.g. espn online updates)for multiple sports. We are using SQL server 2000 Enterprise and Windows 2000 adva...more >>

I have 4 servers A,B,C,D A,B are connected through DSL cable modem. C,D are connected through Network. 7 users works on A 9 users works on B 3 users Works on D 1 user work on C Each 1 week i get Server C to the main office and connected to the network and make the replication. I can stop th...more >>

Hi, I am using SQL 2000 standard edition. When i do a snapshot replication, all the published tables are locked while creating the snapshot. Result is i cannot do a snapshot during work hours. My understanding was that there is an improvement in SQL Server 2000 where by tables do not g...more >>

Hello, I'm trying to enable Subscribers to synchronize with alternate publisher, I go to the properties of the publication and then to sync partners, then I enable the Allow Subscribers to synchronize with other partners than the Publisher from which the subscription was created, but the onl...more >>

I received error message indicating: Cannot insert duplicate key row in object 'MFA_XferPriceValue' with unique index 'COP_XferPriceValueInWorkPK'. The record has inserted in the both databases. Please help me resolve this problem, are a work around to this problem. Thank You, ...more >>

I have servers in a merge scenario that replicate every ten minutes. When changes occur, they need to replicate fairly quickly (within 30 minutes), but changes may not occur in every hour. I think it would be most efficient to run continuous rather than every 10 minutes. However, I would rea...more >>

The system consists of one SQL 2000 Server (Distributor and Publisher) and several subscribers running MSDE 2000 and Merge Replication. Every Subscriber connects to the publisher using Pull Subscription, but the choice of selecting "No, This is a named subscription" is grayed out when establishi...more >>

We have a situation where the customer wants to merge replicate the "completed" rows (a status column in the row) in a certain table, but totally ignore those rows when they are not complete. A filter won't work because it says that the subscriber is entitled to have only certain rows. So, wh...more >>

have SQL Server 2000 Enterprise (the developer edition that comes with Visual Studio .NET Enterprise Developer) Here is the output from a SELECT @@VERSION; Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Eval...more >>

I have SQL Server 2000 transactional replication and it works fine. I need to break the replication to apply the vendor script to the database. The vendor will modify database objects. I delete the transaction replication subscription. I tried to alter a table and received an e...more >>

I have a W2k Server, MSSSQL 2000 SP3 with a merge publication distributed trough FTP. When I try to get the initial snapshot in a w98, MSDE 2000 SP3 in an anonymous subscription, I get this error: sp_MSaddinitialarticle --> Too many arguments. The problem is than SP3 not updates this ...more >>

OOPS! Forgot the subject line the first time I posted this = question..... How do we (transactional) replicate to a database outside our firewall? We are able to replicate out to that database, but how can we pull back = into the network database behind our firewall? Both servers need ac...more >>

I have 20 MSDE subscribtions that synchronize with our SQL 2000 Server that act as the publisher and distributor using Merge repl. and synchronize on demand. Merge replication startet out fine, but after some days the merge agent deletes several rows. Example, if one of the subscribers synchroniz...more >>

Hello, I'm using SQL Server 2000. For a internal security I will create a realtime backup copy of all the DB that I have (~40) to one other SQL Server 2000. Someone can explain to me what can I do? I have to use a tool of microsoft, I have to use one other tool? thank you Milani Omar ...more >>

Hi all, Sql server 7.0 I have replication jobs which replicates the data from one server to another. one of our server was down for some duration of time and the replication job log reader has failed it gives the error msg log reader agent: "the process could not execute 'sp_repldone/sp...more >>

Hi , I am trying to setup Transactional Replication , which adds an extra column 'uniqueidentifier' to each table . This is causeing my many applications to fail as I have many used 'INSERT INTO' and SELECT- INSERT SQL pair . Is there any we I can setup T Replication without having extr...more >>