I have two SQL 2000 servers. I want to make the primary and one the secondary. I want to databases to stay replicated. If the Primary goes down the Secondary would be used while we fix the Primary. Once the the Primary is fixed it would be brought back online and the Secondary would replic...more >>

Hi, I'm trying to set up a subscriber for merge replication over https. The initial snapshot file is about 50 Gigs and I'm wondering if its possible to download & store this snapshot somewhere other than on my database drive (I have size contraints). Any ideas or direction? Thanks, JC ...more >>

Hi, I am testing the replication with SqlCeReplication and the only way I have been able to make it works was by using the PublisherLogin="sa" (or a user with server role sysadmin). What privileges a PublisherLogin really needs? I find it risky to use sysadmin privilege. It's on SqlServer 200...more >>

Hello, I plan to setup an transaction replication for my project but I am very new to this. I have read some documents but still not so clear on how do it. I know that some of you have been sucessfull implement this type of replication. Just setting up the replication I think that is not ...more >>

Hi all, I'm trying to create a subscription for a merge replication on a sql server mobile 2005 based application. The publisher is on a intranet, listening on port 9091 and with a named instance. The merge agent is in a DMZ with port 9091 open for inbound/outbound TCP traffic to the intr...more >>

I am experimenting with replication and recently set up a prototype transactional replication with about a dozen publications and perhaps twice as many articles. All has gone smoothly so far. One item that is causing much gnashing of teeth is the fact that I cannot disable a pre-existing t...more >>

Hi All, I need to drop an article from live merge publication and than add it back again with different schema (column, PK etc’) . I can’t use sp_dropsubscription for every subscriber and sp_droparticle because it is not transactional / snapshot publication. Do I have any other ...more >>

We have a production database that is replicated(transactional). Whenever we have to take a snapshot, it creates blocking on the production tables and causes timeouts within the production application. This is creating big problems and I am wondering if there is away to avoid the blocking which...more >>

Hi There, I was troubleshooting a problem in my transactional replication and notices that SQL Server replicates some of my update statements as Delete/Insert pairs, I was really surprised and couldn't understand why SQL server does that, I found an article in MS support web site http...more >>

Hi, I installed sql server 2005 in two machine and want to set up replications between them, on mahcine A , I want to create a publication and a distributor. I have a administrator account "davidadmin" and password "abc " in this machine(A). In new publication wizard, in Snaphsot Agent Secur...more >>

I see that transformable subscriptions have been deprecated in SQL Server 2005. And although SQL Server BOL tells you how to setup SSIS to run DTS packages it also notes that this will be discontinued in future releases... What is my alternative to transformable subscriptions in SQL Server 200...more >>

Hello. I have this problem. I have 2 servers X and Y. X is only Publisher Y is Publisher and Distributor for X and Y. My question. When i make a publication in X, do i have to set the ftp server parameter for the snapshot in X or Y. I'm having errors on Connections. Thanks in Adva...more >>

Hi We currently use VPN to allow 300+ remote clients to merge replicate to our SQL 2000 server. I am interested in looking at the option of implementing replication over the web as VPN is becoming a support headache and admin heavy. Any comments, resourses or feedback with your experience ...more >>

Hi, Is it possible to get a list of publishers a subscriber is subscribed to? - komp ...more >>

I'm trying to use transactional replication between two Sql2000 sp4 servers. Updates are failing, on the subscriber, on tables with the timestamp column. I'm using sp_scriptdynamicupdproc to create the dynamic update stored procedures. It is adding a timestamp column, to update, to the stor...more >>

Hi, I need to create a UDF that I can call like this: select machinename from fn_Split2(host_name()) My UDF code is this: CREATE FUNCTION fn_Split2(@machinename varchar(11)) RETURNS @Strings TABLE ( machinename varchar(10) ) AS BEGIN declare @m varchar(11) set @m = @machi...more >>

Hi to All, I had sql 2005 with sp3 and i was working succesfully with merge replication on Sql ce. Yestarday i upgrade to sql 2005 (first upgrate my sql200 with sp4) Now i am here in sql 2005 trying to create a new merge replication on windows mobile 2005 and i get to the final step this error ...more >>

We're in the process of writing an application that we want to work with a synchronous mirrored Sql 2005 database and a witness. As I currently understand it the best way to handle failover with this setup is to catch the server not available error and then retry the operation. Any open tra...more >>

Hello, i have this 2 errors. Pleas for help. The process could not check existence of generation at the 'Subscriber'. (Source: Merge Replication Provider (Agent); Error number: -2147201003) General network error. Check your network documentation. (Source: SERWER (Data source); Error number: ...more >>

windows 2000 / sql 2000 in the conflict resolution dialog I get the 'winner' columns listed with data and on the right 'loser' side I see this message instead of data: "The error described above occurred when trying to insert or update this data at the other server. If you ignore this confli...more >>

I am doing some research in advance of setting up replication. I've read about replicating stored procedure execution and I need clarification on what it is exactly. My understanding is that, for example, if you have a stored procedure on the publisher that modifies 10,000 rows then replicatio...more >>

Can I use my backup server as my monitoring server for log shipping? --=20 Tony...more >>

Hi all, I am trying to configure a pull merge subscription in MSDE (2000, not sql express) at installation-time and am hoping someone can help. Here is my situation: I have a publisher/distributer on machine X. I have a client application that uses MSDE as its db. I want to have an in...more >>

When using "Merge Replication", is it possible to have a SQL Server to be a Publisher for one database and a Subscriber for another? I'm not a SQL gury and was hoping someone out there can lend me a helping hand. ...more >>

I am a VB/.NET/SQL developer that has been tasked with restructuring how our field offices return data to the central office so some of this "advanced" SQL Server functionality - like replication - is relatively new to me... and I need your help, please. The scenario: We have installations...more >>

I am experiencing same problem described in article 872843. even though my sql server is on SP4. I try to tweak Log reader Agent Properties & other things but that is not helping. It is my impression whether this bug is not fixed or got break in SP4. Any reply/feedback/solutions/tips will...more >>

Is there a way I can be notified when a merge replication resolves/shows a conflict. Maybe e-mail or something? Thanks, Steve...more >>

We have been running transactional replication from one remote server to our in-house sql server for some years. This morning 4 new fields were added to 4 existing tables using sp_repladdcolumn. All 4 fields were Integer fields that allows nulls. Since making this change to the schema this m...more >>

I was runnung 'Validation Subscription' on our replication server and it try to validate a replicated 'stored --procedure' with the row count and returned with an error : -------------------------- exec dbo.sp_table_validation @table = 'usp_SP1', @expected_rowcount = 0, @rowcount_only = ...more >>

I setup a transactional recplication and selected the 'Do not lock tables during snapshot generation' option so to allow the publication DB to be available while snapshot is being generated. Snapshot completed OK but the distributor returned error: Operand type clash: uniqueidentifier is i...more >>

After I execute sp_removedbreplication for a database on SQL Server 2000 SP3, the Log Reader Agent remains and shows error "could not execute sp_replcmds". How to remove this particular agent? There is replication going on for a few other databases....more >>

Has anyone had any experience with mirroring and replicating a production database at the same time. The mirrored database will be in another state for high availability purposes, the replicated database (transactional) will be used for reporting purposes on site. Is this possible to do both a...more >>

Hi, i have instaled SQL Server 2005 Standard and i have create a Snapshot replication for one of our database. The snapshot should run every 3 hours, but after the first one create during the replication configuration no more snapshot is generated. If i see the replication monitor everythin...more >>

Hi, Is it possible to create a publication without creating a logreader agent at the same time? I'm on MS SQL Server 2000 SP3a. -- Many thanks, Oskar ...more >>

Please, I bought the Book of Hillary Cotter about Transaccional and Snapshot but... I need to know about Merge. He still is not publishing his book. So, anyone know where can i download, read or anything about Merge replication? Thanks in advance ...more >>

I was hoping someone could explain the (IMHO) strange behaviour I see occurring with my SQL Server 2005 identity range management. I am testing merge replication to MSDE pull subscriptions from my SQL Server 2005 Publisher. I am trying to add a number of records (at the publisher) to a tab...more >>

Recently added table to merge, another process is moving the records between servers and beating merge causing conflicts. App so big - dev will have to spend many hours finding cause & resolving. Until then I have to deal w/ conflicts... How do I resolve conflicts when I have thousands of...more >>

I'm trying to set up replication on a Db that I just took over. When replicating the SProcs the Distribution Agent stops with an error on the Subscriber whenever it encounters an SP that is building a dynamic SQL statement. I typically get the following error: are not allowed. Add a name...more >>

Hi, I am attempting a POC to replicate a single table from SQL2005 to Oracle 9i. Although the publication process is working correctly (I can see the published data), SQL is failing with an error "cannot connect to subscriber xxxxx". I have verified, using sqlplus, that I can connect from t...more >>

Hi I have set up a publication on a database in a datacentre which is web enabled. I now need to set up a subscription on a sqlexpress server on a local machine using RMO (or whatever). I do NOT have a 'network' connection to the server and so the normal MergePullSubscription subscription...more >>

I have a SQL 2000 server running service pack 3a with security hotfix SQL2000-KB815495-8.00.0818-ENU.exe applied. IIS and the SQLCE2 merge agent are on the same machine. First time synchronisation to Pocket PC is fine, but subsequent synchronisations fail (i.e. the snapshot gets delivered OK, ...more >>

Hello Everybody I am having merge Replication using MSSQL 2000 sp3 latest security patch, My replication is server1 –Publisher, server2 – subscriber, server3 – subscriber, Server4 – subscriber, server5 – subscriber. I am using schedule around 1:00 AM every day, In Server2 we insert 5 ro...more >>

-Win2003 -msSQL200 sp3 8.00.760 We have a database with 2 publications one native and one Hetrogeneous publication. Is there any trouble to upgrade from sp3 to sp4 (mssql2000)? ...more >>