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 >>

If sp_autostats <tablename> will display the current statistics status of all indexes in the authors table, is there a counterpart for sp_createstats? Based on Books online, sp_createstats will create statistics for all eligible columns for all user tables in the current database. I'm afraid to exec...more >>

I have SQL Server 2000 transactional replication and it works fine. I needed to alter a table and add two tables to the database and the replication article. I delete the transaction replication subscription. I tried to alter a table and received an error stating that the table ...more >>

Using DMO I have one SQL server subscribing to another, however the the subscription is not a continuous one. Having made that is in EM and then using code to compare that subscription with the one the program makes I cant see any differences. What properties do I have to set, or method to c...more >>

I get the following error when trying to syncronize 2 databases configured for merge replication: The subscription to publication '<DBName>' is invalid. (Source: Merge Replication Provider (Agent); Error number: -2147201019) ----------------------------------------------------------- -----...more >>

I have an issue with one of my subscribers getting the dreaded "The Publisher has been restored from a backup whose schema change version is different from the Subscriber." error on one of the publications. I have a total of 6 publications and the error only occurs one of them. After receivi...more >>

Hello I use a merge replication and I can see many conflicts (in differents tables) having the same source error. The error message in Conflict viewer says The row was inserted at 'Publisher.DataBase' but could not be inserted at 'Subscriber.DataBase'. INSERT statement conflicted with COLUMN FORE...more >>

We have an application that runs with MS SQL 2000 (SP3a) which is used for tracking information from multiple sources. We are shortly going to be setting up replication of this database with a secondary location, with a third location planned by mid year. We know that there will be other locat...more >>

Hi - I am an extremely novice user attempting to use transactional replication. I successfully ran the replication and then opted to remove the subscriptions, publications and so forth and start again. I did not remove the distributor. I may have removed jobs associated with the distributor t...more >>

Thank you for all the guidance. I guess I have my alternativities clear. Thank you very much. Now I have another issues to address and if someone has experience in this I would really appreciate the advise. Right now we are implementing the second site, eventually we'll have 5. 1. I need t...more >>

I have merge replication set up with a publisher and two subscribers. All of my primary key fields are set for autoincrement (not for replication). The articles in the publication are set to force the subscriber to use a range for generating unique primary keys. Things seem to go well for a while...more >>

dear friends, any idea that can make the merge agent doesn't replicate the updated data from the subscriber? although the agent status is successful and this message appear ' no data needed to be merged' , although there was data modified...more >>

Dear Friends, i'm facing a strange thing with merge replication , the merge agent is running and working successfully displaying the message 'no data needed to be merged' although alot of modificatins is been made to the subscriber. and i stoped the agent and run it again , same message...more >>

How do I stop SQL Server Agent in SQL 2000 via a SQL statement?? Thanks.......more >>

Running SQL 2000 & Win 2000. My main server was upgraded/replaced today. We stopped SQL on the ond server and copied the dBs to the new server, which has the same name as old server. I receive the following message on all my subscriptions from my remote locations. The job failed. Un...more >>

Hello, I have a problem when trying to publish articles for merge replication. During execution of the snapshot agent I receive the following error "The process could not bulk copy out of table '[dbo].[table_name]'. Can anyone help me with this problem? Any help at all would be great...more >>

A few days ago I posted a problem I am having with push, one way, transactional replication failing to replicate updates to the subscriber. The identity field is set to Not For Replication on the subscriber and the inserts work, however, my updates are failing with a Cannot Update Identity column. O...more >>

Hello Everybody, Thanks to all of you that have answered my basic questions, I really appreciated. I have some doubts related to the updating subscriber scenario. * When we talk about updating subscribers, we are talking about transactional publications ONLY ??? * If I imp...more >>

for a couple hundred users... These folks currently replicate several Notes databases at least once a day Do you think I'm crazy for considering a new solution with SQL Server in the middle and MSDE or SQL Personal edition on all the remote machines? Is it feasible or am I trying to fit a sqaure...more >>

I have merge replication set up with a publisher and two subscribers. All of my primary key fields are set for autoincrement (not for replication). The articles in the publication are set to force the subscriber to use a range for generating unique primary keys. Things seem to go well for a while...more >>

Hello, I have this problem, I have transactional replication setup with 2 table as article for a publisher. Consider a transaction which inserts one row into each of these table in the publisher database. At subscriber database one of the commands suceeds and the other fails (lets say be...more >>

Hi, I had did replication from SQL Server 2000 to Ms Access in same server. Now, how I do it replication back to SQL Server from Ms Access in same server also. very Urgent!! Thanks You....more >>

I have a subscription that has expired. I need to be careful to preserve the data that resides at my subscriber. I have two weeks worth of data at the subscriber that needs to be synchronized with the publisher. Any recommendations on the best approach to get my subscriber back in sync? ...more >>