Firts we create 12 publication, each with many articles, all initialize and sincronism ok. After that, we just use one aplication to manipulate data at publisher. Twice error 18805 appear. The Log reader can not execute and this message become: The process could not execute 'sp_replcmds' on '...more >>

I have a SQL 2005-2005 Express Merge replication. Articles with FKs. Added a new subscriber, when I initialize it, some tables are updated more 190 times. For example, customer table has 100 records, however the initialization inserts 100 and update 19000 rows. It makes the initialization too...more >>

I am curious if a "session" for merge replication is a transaction. If I see 100 actions in the Agent History and the last one is "the process could not enumerate changes at the subscriber" due to General Network Error (dropped connection or whatever), did those 10000 data changes get commi...more >>

I'm trying to set up transactional replication using SSMS. I had no errors creating the publisher and distributor but had warnings when the subscription create was running saying that another sa process was running. I'm new to this and do not know how to get the snapshot to run or see why it ...more >>

I'm new to replication and maybe I'm missing something. I set up replication from one server to another (push). The replication is working fine every hour, but I have to start the snapshots manually. If I don't, no replication takes place, because there are no changes in the snapshot. I ...more >>

Hi, Is there a way where I can add a table to an existing publication in SQL 2000 (both publisher and subscriber) and get the transactional replication to work without generating the snapshot of the whole database ? There are few tables who have columns omitted from the existing publication...more >>

I am trying to setup a merge (push) replication to a server/database in a remote network. I created the publication and connected to the remote network using VPN but cannot register nor see the remote sql server. In sql server 2000, I was able to register the server in my Enterprise Manager (...more >>

Does anybody know what could cause this error: The schema script '\\SERVERP\ReplData\unc\SERVERP_ANIL_ANIL \20070626175153\ZEZALOGADATUM_1.sch' could not be propagated to the subscriber. (Source: Merge Replication Provider (Agent); Error number: -2147201001) ---------------------------------...more >>

I set up a transactional, pull publisher, distributor and subscriber last week on a development system and all worked fine. Then, I did the same set up on our production system and it is not working. When this was started on Thursday night the distributor would not start. I was not here Fri...more >>

Hi, We have a product that configures on SQL 2000 and also configures the replication. We are in the process of doing R&D on SQL 2005. Following are my machine specifications OS Type : Windows 2000 Server (SP4) SQL Server : SQL 2005 When i try to create a publisher and a subscriber, on th...more >>

Hi, I am using MCALL for updates sql statement, I know MCALL only replicates the changed columns, however is it possible to force a certain column to be replicated even there are no changes to it? Thanks in advance. ...more >>

Currently, we have many MSDE instances that subscribe to our main server. Morning, we have to re-init whenever there's a failed subscription. Is there a way or script to automate the reinitialization? Also, how can we indicate it to use the current snapshot or generate a new snapshot? Thanks...more >>

I'm experiencing an intermittent issue with merge replication after upgrading one of the subscribers to SQL 2005 Express from MSDE 2000. Here are a few details about the environment before I describe the issue 1. Originally was SQL 2000 Standard Publisher with MSDE 2000 Subscribers all SP4 2...more >>

Hi, I have the following setup: OracleDB SQL2005 SQL2005Express There's a transactional replication between OracleDB and SQL2005; and there's a merge replication between SQL2005 and SQL2005Express. Changes made in OracleDB properly synchronized into SQL2005, but for some reason Mer...more >>

I have a database where some tables have the IDENTITY = YES. If I copy or export from ServerA to ServerB, the IDENTITY gets set to No. This has to be a simple problem. How is it fixed? ...more >>

Hi, I'm trying to run the wizard to setup replication on a SQL Server 2000 SP3. Entering the parameters goes without a problem but when executing the script I'm getting an error 14113: SQL Server Enterprise MAnager could not configure 'XYZ' as the distributor for 'XYZ'. Error 14113: Could...more >>