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

In the replication scenario I am dealing with, a mobile device (PDA) uses SQL Server Mobile to synchronize data with a SQL Server database located on some server. The mobile user can enter new data on the PDA. Data replicated from the server to the PDA cannot be modified. However, after a long p...more >>

I am working on a script to run in Query Analyzer to run all of my SnapShot agents manually rather than wait for the schedule to do it. I am using sp_start_job to run each agent such as: exec msdb.dbo.sp_start_job @Job_Name='SQLSERVER-SomeSnapshotAgent-167' waitfor delay '00:30:00' --some fi...more >>

Publisher: - Windows 2000 SP4 - SQL Server 2005 Standard Edition SP2 Subscriber: - Tablet XP SP2 - SQL Express SP2 - VS 2005, .NET 2.0, SMO & RMO coded in C# Hi, We have a publication that uses parameterized filters. I followed the steps listed in the RMO documentation and coded a ...more >>

We have a SQL2005 merge replication database with 8 subscribers. Three of the subscribers have not successfully replicated. We would appreciate any additional ideas for correcting this. So far we have some inconsistencies. For example, the "View Synchronization Status" displays: "Downloaded 1...more >>

Hello, I have a several PPC app that use replication on seperate IIS and SQL (2000) boxes with great success. We recently set up our first 2005 SQL install. It happens to be on a x64 machine. I am trying to use the same IIS set up and just have it replicate with the same database that has been m...more >>

We want to publish a row filtered table where each subscriber can have one or more of the row partitions. We'd prefer not to have separate databases or tables for each partition at the subscriber. We've look at various scenarios, transactional repl with DTS filter, merge replication with dynamic...more >>

Hi, MS SQL Server 2005 RTM. Could anyone please point me to a good source describing how the automatic identity range management works for merge repliaction or explain it? In particular, how the options of Publisher/Subscriber identity range size in Managemen Studio work, preferrably with e...more >>

SQL Server 2005 SP2 Windows 2000 SP4 Merge replication with client pull subscriptions Hi, Questions about replication agent jobs: 1) We changed a password on the user account that we run our agent jobs under. In management studio I clicked on the "Change Replication Passwords" butt...more >>

22 of my 36 distribution agents currently show a total of 400,000+ undistributed commands in MSdistribution_status, but if I look a the agents individually in SQL Server 2005 Replication Monitor they all show 0 undistributed commands. And if I use sp_browsereplcmds to get a specific insert ...more >>

I've deleted the publication and even disabled publishing completely, yet one particular table still thinks it is replicating. Things I've already tried: sp_dboption databasename, published, false sp_removedbreplication 'mydatabase' sp_msunmarkreplinfo 'mytable' The replinfo value for thi...more >>

Hi: Latency is very high in replication monitor even though I don't see any commands to be applied in sp_browsereplcmds. Do you know from where it gets the latency number from in distribution database because it is misleading? Thanks...more >>

I'm using the "SQL Server Update Wizard" to migrate SQL Server 6.5 databases to SQL Server 2000. When I try to connect to export server (SQL 6.5) i get the following error: "Unable to connect to the Export server. Please verify that you are an NT Administrator on that machine." Both servers u...more >>

Hi NG, I have a question regarding foreign keys and replication order in a merge replication. In our database (SQL Server 2000) are about 60 tables and 90 views. I created 2 merge replications on our server, it's now configured as a publisher and a distributor. The destination server do...more >>

Hi all, I want to know whether I can capture the SQL statements occuring when a replication is taking place. (Eg : Database A, Table1 is updated in a replication. If I run the profiler will it give the update statements used in it ?) Best Regards, RJ ...more >>

Hi All, I'm trying to use the Windows Synchronization Manager to handle the data synchronization in an anonymous Pull Subscription for a Merge Replication. I have set all the details and properties for the sync and it all works. Problem is, the only retained properties for the Login details...more >>

Should I use the domain administrator for the mssqlserver and sqlserveragent services log on account if I am setting a transactional replication on a remote server? Also, How do I restart the distribution agent if it fails? I can see the status of it but cannot find the restart property. ...more >>

In a transactional replication scenario, should i consider rebuilding indexes on the subscriber articles? Does that place a lock on the subscriber? most of those tables are used only for select queries. Thanks. ...more >>

Some problem happen from Appliction side & it was brought to my attention that i have to restore the production database & same production Database is used for transactional replication. i am not sure if i restore the database it will break the replication or what is better way to RESTORE. any h...more >>

Hi, We have a requirement to update a sub set of data to multiple databases over the world using SQL 2005 Standard (Each SQL server may have more than one DB that needs updating). We could use a push (or pull) filtered snapshot replication to each database achieve this. However, some of the ...more >>

I set up replication on a database and the next day a colleague restored it using a copy prior to replication. I now have an unpublished database that SQL Server is convinced is replicated. In Replication Monitor I have a red cross against the two publications on this database. I have no it...more >>

Hello, We have a mixed replication environment with SQL Server transactional replication and Datamirror replication (with DB2). Yesterday we upgraded to SQL Server 2005 and the transactional replication does not work. The log reader message is "Logscan in progress. Approximately 4254920 l...more >>

I have a 5 computer system been replicated to a server with MS SQL 2000 server. The database is called Lab2 and the space in disk became too short to work. I asked my assistant to delete some part of the data. I do not what he did, but now the database does not exist, and the publication is sti...more >>

I want to implement transactional replication for failover purposes. I need to replicate data from a primary database to a secondary one that will be used if the primary goes down. In the event of a primary failure I need to switch the applications to run off the secondary. When the primary is...more >>

While trying to configure replication from and to SQL Server 2000 boxes, I encountered the following error, which I was not able to get past. The error is encountered after completing the "Push Subscription Wizard" which is set to create the database and initialize the schema and data. The dat...more >>

sql2005 standard edition In replication monitor, under Publication tab, the Current Average Performance and Current Worst Performance show "Poor" for one publication, and this has been like this for a few days. The publisher server is not under heavy load at all. In Perfmon I checked Del...more >>