I have set up a simple transactional replication that includes specified columns in one table. One of those columns is used in a unique key with the ignore_dup_key option set to 'on'. When I tried to get the replication started, it fails with this error: 'IGNORE_DUP_KEY' is not a recognized A...more >>

Urgent pls, When we configure SQL to SQL Transactional replication along with the table creation at the destination it also creates 3 storedprocedures. Example Replicate table Employee, in the sch file or script file it will have script related to create table and create procedure sp_msins_em...more >>

Hi, We are tryin to do merge replication between a SQL server standard edition on a desktop acting as publisher and SQL mobile edition on mobile device acting as subscriber. We folllowed the steps in here http://msdn2.microsoft.com/en-US/library/aa454892.aspx and everything worked jus...more >>

Hi guys, I sent this same message to the connection newsgroup, but I thought it wouldn't hurt to post it here too. We use replication, so a few clients connect to the network database, and sometimes to MSDE on their computer when outside the office. They use their domain Windows a...more >>

Hi guys, We have a client who wants to set up the publisher (for merge resplication) on a particular domain, but the subscribers will be on a different domain. Is this even possible? The main question was about the snapshot folder location. Is there a way for the subscriber t...more >>

Hello, I have a publiction on my development box using SQL Server 2005 developer edition. I created a subscription for my test box, sitting next to me, intialized and synchronized with the subscriber. I also have SQL Server Express installed on my development box. I created a subscription for...more >>

In a merge replication system, are there any command (stored procedure) that can force a syncronizing, so the user do not need to wait for the scheduled time for syncronizing? Anders Balslev...more >>

I need to sync a table which has millions of rows. The idea is to backup-restore. Create the snapshot agent and subscription with sync_type = none. However when the snapshot runs the article is bcped out too. The bcp file is 36GB. Why does it bcp article table when it is not going to apply?...more >>

I desperately need a solution to my application I do have following servers in a replication system: Server 0 (which is distributor and Publisher) Server 1, server 2, Server 3 - All subscribers. On all servers I have a database "Family" On these database, I have 2 tables: 1 : tblParents -...more >>

Hi, When I configured web synchronization, I chose the checkbox that says do not use SSL. Subsequently, I reconfigured it to use SSL, but I get an exception "A request to send data to the computer running IIS has failed" when I tried to perform replication via my application. However, wh...more >>

Is it possible to upload data in a single table from all subscribers to the publisher in a merge subscription? All subscribers and the publisher are running SS2005 (Express edition for subscribers). I'm familiar with the download only option from publisher to subscribers, but need to do just...more >>

I have this problem when I re-initialize a transactional replication its still looking for a old snapshot folder. Even after i create a snapshot, its still looking at the old folder. Any way to force it to expire the old snapshot? Any advise is much appreciated.. Regards, Aravin Rajendra...more >>

Hi, I install Sql server 2000 on a server named JMI_SQL After Installation we decide to rename the server JMI_SQL for SQL2007 I create a Distributor on the server SQLDIST2007 Once my distibutor created i try to create my Publisher on SQL2007 and I receive this message Error 18482 Coul...more >>

When we script our replication creation and push the initial snapshot, at times it wants to create the views first before the tables,etc.. and want to know how to create them in order. I was hoping SQL would be smart enough to do so.. and now we have to create seperate publications that includ...more >>

I need to reinitialize an existing transactional replication set up (SQL 2005 set up with gui, used a snapshot to initialize) it was running fine up til now, both databases are in sync, but now it's saying it needs to reinitialize. Is there a way to do this without using a snapshot? The databas...more >>

I am converting some code from SQL2000 to SQL2005 and I am at the part where I start a pull subscription merge agent by looking up the merge_jobid using the sp_helpmergepullsubscription stored procedure and then use that job id with sp_start_job. This works fine for SQL 2000. When I tried ...more >>

Hi I need to performed following steps on MSDE 2000 using programming or T-sql insted of wizard. 1. configuring distributor and publisher 2. creating new publication ( Merge Publication will subscibe by SQL server CE 2.0 ) 3. configure IIS for connectivity support. please any body ha...more >>

Hi everybody. I have a merge replication scenario between 2 servers. The replication works successfully, the problem appears when I try write a register in a table, WHICH is not an articule in the replication! Everything is OK when I write data in the publicator. But when I write registers in t...more >>

We are using Merge Replication on SQL 2000 The snapshot on our publisher has a 180 day retention period. We are able to add new subscribers just fine within that 180 days, but it seems that come day 181 when we add a new subscriber it is missing a bunch of schema information that it should...more >>

we have a transactional replication on 3 sql 2005 servers, which acts as pub, distributor, and sub. Now I want to replace the distributor server with a new server. my question is: Can I setup this new server as second remote distributor? so we can move the replication to this second remote o...more >>

The problems I have encountered with SQL 2000 transaction replication are as follows: 1. There a lot of tables with identity columns. 2. There are about tables that don't have a primary key, thus they can't be replicated. 3. Replication only monitors Insert, Replace and Delete commands in ...more >>