Hi, I'm trying to set up a merge replication application on a production server and I have run into problems. I'm trying to use SQL server Mobile to connect to a SQL Server 2000 publisher but I get errors when I try to syncronize. I've tested the application in my development enviromen...more >>

Hi We are using SQL 2K with Sp4. Both publisher and distributor are on the same computer. We are using push repication. Recently I changed the sa password without knowing that somewhere in our push replication is using it. When I create a new subscription, it keeps on telling me that ...more >>

Does sql server 7.0 support @force_invalidate_snapshot parameter?...more >>

We have a database in which global updates must be periodically made to multiple records, usually in the hundreds or thousands. Is this a problem when using Merge replication? Because there are individual merge triggers on each table, is it preferable to use a cursor to make global changes?...more >>

Hi, For a publication we have, I need to increase the value for "max text repl size". On which servers in my replication topology do I need to set this option? The publisher, distributer, and/or subscriber? -- Thank you, Daniel Jameson SQL Server DBA Children's Oncology Group www...more >>

I have a transactional replication setup. The table has an identity key (SID) which is set as a unique key with no replication. However when i try to run the distrinution agent i get error 8102 "Cannot update identity column ESID any ideas? ...more >>

Hi, I want to add a table/article that I have removed before some days because of some problems. Since I'm using transactional replication with "nosync" initialization I don't know how can I add to the replication one article. Thanks, BaniSQL ...more >>

I have a situation where a customer has a SQL 2000 database at thier office location, this is where they do data updates, it replicates to a SQL 2000 server located at a web hosting facility. Problem is there is a new IT guy at the office location that has done something to the setup so that ...more >>

I have a SQL 2005 cluster running, now the client would like to have the dataset replicated to another SQL server offsite for further redundancy. For the time being, the offsite server will be a stand-alone, however in the future it could become another clustered solution. The network connecti...more >>

Hi All, Just a stupid question for you all :) We have log shipping set up (SQL 2005) and running perfectly fine. We have one primary server and one secondary server with one database. Occasionallyi would like to manually enter a query or procedure on both the primary and secondary ser...more >>

Hi Guys; What proc would I use to add an existing column to an existing merge publication? I realize that an entire reinitialization will have to take place :( I've looked at options on sp_ReplAddColumn, and I've looked at the one that changes properties on a publication, but neither seem...more >>

Hi I am trying to setup a transactioal replication from 2 servers to 2. I already have a table that has an owner that is not dbo (lets say user1) Whenever i setup the replication if i tell it to create schema and data, it create dbo.table on the detsination. If i chose to not create (the de...more >>

can someone explain the proper usage of a queued updatable subscriber in a transactional replication scheme? in other words, what are the ways in which you can tell the subscriber to empty the queue of outstanding transactions that are to be applied back at the publisher (keep in mind, althoug...more >>

Can I make a backup of my Publisher DB and then restore it on the Subscriber, or this operation can generate problems? ...more >>

SQL Live-Live – what are the options for the DB clusters to be in an ACTIVE/ACTIVE configuration with multi-master “merge” replication? What is the network requirements, what about data integrity, latency, performance? Basically I am trying to design a new SQL Database infrastructure to...more >>

Hi, I've got a unidirectional transactional replication (on sql 2000) and I want to add a column to a table on the subscriber's side, the column allows nulls and is going to be updated on the subscriber. I thought of creating the table, than adding the publication and when I add this specif...more >>

I'm going through the documentation for SQL Server 2005 replication and am trying to understand what type of publication I should be using. Here is how replication should be working in my system: I have a database on a server that will be accessible over the Internet. This database can be used...more >>

When using merge replication and all subscribers use the same subscription and when two or more subscribers insert new records, does replication on the server automatically modify the unique ID field for that record. In other words, if mobile user A inserts a record and the ID field automaticall...more >>

Does anyone know why Microsoft has decided to do away with Sync Partners? I know they have given the reason the fail over is not automatic and the alternative is using Database Mirroring. However you can write a job or even a replication tool that will automate the failover process and the user ...more >>

Hi. I'm trying to establish whether Transactional Replication with Updating Subscribers meets my requirements. I have chosen to use "publisher wins" for the conflict resolution. (I'm using SqlServer 2005 Developer Edition on Win XP SP2 on both machines) When I cause a conflict to occur by ...more >>

We have 50+ clients that use a pull merge subscription. There are 2 databases and each databases has only 1 publication. Each client has ONE subscription to each of the 2 databases. We had to set the retention to unlimited to avoid the following error: The Merge Agent failed after detect...more >>

Hi I have read-only access to an SQL server which I want to replicate from. The owner of the server does not want to set it up as a distributer, so I can't subscribe to it. I have read somewhere that you can replicate from OLE DB and ODBC connections. Presumably in this case the data so...more >>

what if you know that the subscriber will NEVER insert, only update? for one, this would mean that you don't need identity range mngt right? do i still have to set the identity to NOT FOR REPLICATION on either side? anything else less that has to be done in such a scenerio of inserts only occu...more >>

Hi, I have SQL 2005 Transactional replication setup, simple one way to a reporting server. I recently had to add a new non-clustered index to the publisher and it won't replicate to the subscriber. I went to articles and highligted the table and selected 'properties of selected table' and bo...more >>

Hello, I need to change the distributor role from one production server to another new server. I have 15 servers replicating (transactional) to one central server, which is the distributor too. Of course, I want to change this role to another new server. I have been tested some processes...more >>