I have a merge replication environment with one host is publisher/distributor and one subscriber. The merge uses continuous replication. My MSSQL's are 2000SP4. The process could not enumerate changes at the 'Publisher'. (Source: Merge Replication Provider (Agent); Error number: -214720099...more >>

Hello, We have a number of tables for which we need to setup a push type replication. In the source db, the owner of those tables is dbo, but in the subscriber dbs, all tables must belong to a different owner (our application requirement). As I followed replication wizard, I could not find...more >>

Ok, so in my scenario, if I have a one way trust & am already = replicating to the DMZ, I should be able to setup a publication on the = DMZ & pull, right?...more >>

Hey. I've my merge agent to run on continous. I make some change at the publisher and wait for it to replicate over but it takes about 9 to 10 minutes to replicate over. Can someone tell me why it takes so long? What are the steps involved after the change is made to the publisher side. a flow...more >>

I have a replication setup that uses Dynamic filters and dynamic snapshot folders. I also use the keep_partition_changes flag to define which changes are required at each subscriber . The end target is replication to SQL CE. During testing I am using a pull subscription to a sql databas...more >>

Hello, Server A and B are both running on NT4.0 SP6. Server A and B both have SQL Server 2000 SP2 installed. Server A is the Publisher and Distributor. Server B is the subscriber. At one time B was able to see and subscribe to Publication on Server A. I manually deleted all traces of r...more >>

I thought I read that 2000 transactional replication used a ROW Guid on the subscriber. But I just looked at the test instance I set up and I see no such thing. If Sql Server does not use a RowGuid, how does it keep track of everything? just by the primary key?...more >>

I'm about to implement transactional replication from 2000 to 2000 for a "failover" type of situation. That is, if we lose the publishing server, we can pretty easily point various apps, etc. to the subscribing server. But that leads to a couple of questions if such an event actually occurs ...more >>

I am using anonymous merge "pull" subscriptions to synchronize a SqlServerCE database and a SQL 2000 database. The handheld (PocketPC) users are entering data, which is replicated to the SQL 2000 database. This is all working as expected. The only thing I am missing is the ability in SQL 2000...more >>

Hi, I am using a transactional replication in a database and I don't need to transfer data from subscriptions. The subscriptions are only for read locally. I have some questions about replication: - Why the number of transaction is so high? Reach 743952 transactions and ...more >>

Guys, Merge replication server A to server B with NOSYNC option. (identities odd at Server A and even at Server B) I want to remove a table from merge replication. Regards Javed ...more >>

hi all: In my sql 2003 i have several publishers, now i got a problem that it display a red across error in replication monitor , but there is no red across error on any one of replication when i spread publisers. And this red across in Agents folder as well which is under ...more >>

Hi. I have successfully developed a pocket pc applicatoin that synchronizes data using SQL Server replication - it was easy to setup and works great. When configuring the publication, the snapshot must be created on a network share (\\computer\snapshot). How can I get this to work if I ha...more >>

When removing and resotring a replicated database I have an issue where a conflict table wont remove itself as it is expecting the owner of this table to be the same as the owner of the table it is replicating. I have been searching the internet and have found another post that sums it up we...more >>

Hey. I've set auto id ranges in my publication. when i do dbcc checkident(tablename) on pub and sub, it shows me different id ranges. i ran a sp_adjustpublisheridentityrange pubname and it said 'the command completed successfully'. I can do updates and deletes at the sub and it gets replicate...more >>

I'm trying to do a merge replciation between two servers however the merge agent fails announcing that: "The remote server is not defined as a subscription server (The error number is 14010)". Here are more details: The first server (publisher & distributor) has SQL Server enterprise edition ...more >>

How do I get a New UDF to propagate to Anonymous Merge Subscribers? SS2K SP4 Added New UDF <fctrptTeamReview> to Database using Wizard Tried CREATE in Query Analyzer, then though there might be a Stored Procedure . . . No joy! Checked BOL, Hilary & Paul -- Aubrey Kelley...more >>

I've set identity columns to automatic ranges with merge. The publisher ranges is for a million and the subscriber side is for a million. Now, when I go to the EM, and go to the Desgin Table in EM for a table, I see the identity seed to 1. Is this normal? But when I ran the script and everythi...more >>

Hi , i was hoping someone could help with another problem i had with replication. For the purpose of this discussion, I am replicating from dbA to dbB. I had to add a column to one of my tables (tableA) that was involved with replication. So I: 1. stopped the logreader, snapshot (which w...more >>

Hi, could someone tell me the proper sequence to starting up transactional replication? I have 3 services: snapshot logreader distribution All are currently in stop status I do the following: 1. start up logreader 2. start up snapshop 3. wait till snapshot has run to completion ...more >>

I am trying to understand how/where DNS or IP address information is cached that affects only SQL Server replication. I have a server that has merge replication set up with 12 locations. All was running OK until our ISP changed our "static" IP address. While waiting for our ISP to fix the pro...more >>

I have a merge replication environment with one central publisher/distributor and 35 clients. The merge uses continuous replication. At the moment, 31 of the 35 subscriptions have error this error: The process could not check existence of generation at the 'Subscriber'. (Source: Merge Replica...more >>

Once I have merge replication setup for my client using SQL Server Express (with my publisher being SQL Server 2005 Standard), and let's say my client copy his database files to another client with SQL Server Express, can both clients continue to merge replicate to my server? Or would the new...more >>

I'm looking for information about how execution plans are created and revised for a read-only subscriber. If I have multiple read-only subscribers of the same publication, do they create their own execution plans or do they get them from the publisher? Can we issue a dbcc free procedure ...more >>

I've followed the steps in an attempt to replicate to & from the DMZ sql = server. =20 It's a one-way trust. Replication, Trans. Repl w/ Immediate Update is setup My domain sql server can replicate to the dmz, but when I try to change = something at the subscriber it tells me=20 "SQL Server no...more >>

Hi, On SQL SERVER 2000 SP4, when I create a simple merge publication with defaults on a test db, it does not create syspublications table. Why? In order to use sp_adjustpublisheridentityrange it must be in the publication database. NOTE: In BOL, it is written that "sp_adjustpublisherident...more >>

The title about says it all. For merge replication, I need to make sure the service packs match up between SQL2000 and SQLCE. How do I tell which SQLCE version is in? ...more >>

-- Adding the transactional publication exec sp_addpublication @publication = N'mam02 - configuration data - without item', @restricted = N'false', @sync_method = N'native', @repl_freq = N'continuous', @description = N'Transactional publication of mam02 database from Publisher VSQL14\ENTERPRI...more >>

Hey. I've a merge replication setup here. I've to add 2 tables to the existing publication. I know how to do this through em. Now the problem is, I've to remove the non-clustered indexes from the table/article properties. But when i do that, it tells me "Are you sure you want to change this p...more >>

I followed the steps Manually synchronize replication subscriptions by = using backup / restore. Here's what I did; Set up Publication Changed identity columns =3D Yes, Not for Replication (So, both db's = have this value) Backed up Publishing db Created Subscription - Selected No Subscr...more >>

I set up yesterday on a dev 2000 server two sets of replication from the same database: 1. Transactional to another dev 2000 server of about 15 tables. 2. Snapshot to the same dev server and database in #1 of about 3 tables. (The reason I use snapshot replication here on these 3 tables is t...more >>

Hi, I try to set up Simple Log Shipping in SQL Server 2000 Standard Edition, from my reading from the Internet, it need sp sp_ShipLog. But I don't know where I can find it, could someone give me more information about how to set it up? Thanks, Jack...more >>

1. Hey, I've a replication setup at my place. If I right click the replication folder in EM and do a generate SQL script with the default options. Then I do a replace on the server names and stuff in that file. Now, if i run it on another server, will it setup the complete replication model...more >>

Hi: I need to detach and detach the publisher database in transactional replication. To do that, I need to disable publication from this database which will also remove all the publications for this database. I will script all the publications before I disable. After attaching the data...more >>

I setup merge, but when it was attempting to connect to the subscriber I received an error (don't know exact text) about not being able to find column rowguidcol. I ran: SELECT name FROM syscolumns And found lots of entries for rowguidcol, which is odd because I don't name it that (each row...more >>

I have the most perplexing issue with merge replication. This is a configuration that has worked well on several other systems, both XP Pro and Windows Server. This installation is on an XP Pro box that is set up as close to identical to the development machine as possible. I'm getting the ...more >>

I have noticed errors when Clients synchronizing over the internet have the "Automatically Detect Settings" connection setting in IE on. The process fails with an exception mentioning the failure to find the autoconfiguration URL. When browsing the internet, IE gracefully ignores that setti...more >>

I have been using SQL 2000 for a couple of years now in rather standard fashion. I have never had cause for utilizing replication until now. So, in other words, I am very much a newbie to SQL replication. We currently have a SQL 2000 server holding several databases that contain productio...more >>

I've got some basic syncing q's for one way, immediate, transactional replication: 1. What is the "white paper" recommendation for syncing up tables using one way, immediate, transactional replication? It seems from the responses I've gotten that you should be able to sync one time and ju...more >>

I attempt to replicate a non dbo table, e.g. user1.table1. In the mean time dbo.table1 exists in both publisher and subscriber and is replicated. When the replication ran, it drop the dbo.table1 in subscriber and created new dbo.table1 from user1.table1. How do I replicate non dbo tables whe...more >>

Hello, We have active/active SQL2000 SP3a on a Win2k3 cluster in our domain. We need to copy some tables from a database out to our web server. The web server, is SQL2000 SP3a on Windows 2000, SP4. It is a stand-alone server out in the DMZ. We get the following error when trying to d...more >>

I've got 2000-to-2000 immediate, one way, transactional replication set up. I am curious about something: if I go into the Publishers tab on the server that is the "master", i.e. distributor and right click on the publication one of the options it gives me is "Delete". But I know it's criti...more >>

Hi I am just getting up to speed on replication so please forgive me if I am missing something simple here....... Scenario Application server (call it Test) that has SQL Server 2000 database I am setting up replication for backup pupopses (If Server A dies - point Application (Test) to Serv...more >>

Hi, I tried setting a server up as the publisher, distributor and subscriber. When I tried to create either a push or pull subscription I got the following message: Error 14053: Cannot load the DLL replincrementlsn extended procedure, or one of the DLLs it references. Reason: 126(error n...more >>

Hi everyone! How can I do to copy the data and the indexes from an existing table on a database to a new table in another database? I've tried with select * into base1.table1 from base2.table2, but it only copy the data and not the indexes. Can I do it by code? I'm trying to avoid the use...more >>

I want to implement one-way, immediate, transactional, 2000-to-2000 replication with about 20 tables and one database. Of course, it's always the maintenance that is usually more involved than the set up. Let's say I'm going from ServerA to ServerB and I notice that somehow, someway 2 tran...more >>

Hey. I have successfully setup Merge and transactional pubs on a serverA as publisher and serverB as subscriber. Now, I want to partition the data in ServerB and send it back to serverA in a different db. This is in testing. In prod, it'll be going to a different server. The problem is that th...more >>

Hi, We are Merge replicating about 50 Production databases. We had planned to monitor the meta deta clean up error during replication. While we were monitoring the data to be updated during replication in one of these databases, noticed 4 records to be merge replicated ( 3 insert and 1 upda...more >>

Hi, I am dealing with merge replication. The missing statistics event points out [MSmerge_tombstone].[rowguid] in all our databases. Noticed that no specific index for rowguid created in [MSmerge_tombstone] table specific on this column. We would like to know why there is no index created...more >>

Hi, I have configured my system as a Publisher & Distributor. I have also added another machine in my network as the Subscriber. I have used 'Transactional Replication' method. So when I am trying to initialize the Replication, the Subscriber, in Status says that, 'Searching for the Initia...more >>

I get the following error message when I run replication that I have set up on one of our servers. I have no ideal why, any help would be appreciated. This error is from the application log on the replication server to our web server. I think it is because it is trying to login as user "null...more >>

Hello, I am synchronizing a SQLEXPRESS client to SQL 2005 Pro server (Both final release versions) using Web Sync. Everything works great, but after a few syncs I get sync errors. If I go to replisapi.dll?diag I get: replrec.dll classes FAILED. A server reboot fixes the issue, which simp...more >>

I am trying to set up one way transactional replication from one dev 2000 server to another. I have been using the wizards and cannot for the life of me figure out how to add the subscribing server. In other words if I am replicating from Server A to Server B, I cannot figure out a way to ge...more >>

I have read through the materials and still don't feel like I have a definitive answer to the following: does (one way) transactional replication require a primary key on all articles/tables? THx....more >>

Is there a script somehwhere which would alter all constraints and recreate/alter triggers with NFR property set to 1? or would one of you guys know of an easy way to do it? Thank you. Tejas....more >>

I'm trying to use replciation between two computers that run SQL Server that has been installed using mixed mode authentication, but the replciation fails. Here are the details: The Publisher/Distributer - I have installed SQL Server using mixed mode authentication and used a blank password f...more >>

Hello, 1. I have made my database server as Publisher & Distributor for a database. I have added another server into my network, and I have configured that machine as the Subscriber using Wizard. So when I run the Publishing Agent, it runs fine without any problem. But in the Subscriber ...more >>

Message Another distribution agent for the subscription(s) is running or the server is working on a previous request by the same agent.I have two Transactional publications that were setup as push subscriptions, occasionally when the distribution agent failed the spid did not complete and whe...more >>

I have one way merge replication. By mistake i have updated a huge table without the where clause. This thing is blocking my replication. How to rectify this issue? ...more >>