I am having a problem with configuring publiushed and distributor .i am selecting the option to make the local server its own distibutor. After competing the task, I am getting an enterprise manager error stating that Sql server manager could not configure the "SQLSERVER' as distibutore for ...more >>

Using Push Merge Replication I am looking for a one step process to apply a Column change to make the column allow Nulls where the column currently does not allow nulls (NOT NULL). The table is currently published. So far I can only think of a three step process which requires two intermedia...more >>

Please be patient I am a noobie :) We have a Query created in Query Analyzer that we would like to run nightly. How do we get this query to run on a schedule and update tables?...more >>

How do I determine the current retention period for merge publication ?...more >>

Using merge replication, I've decided to change over to identity ranges (versus uniqueidentifiers). At the publisher, I'm setting a range on the tables that would be consistent with the records expected not to be exceeded in the database. Since these values are for an entire state of consumers...more >>

I have two machines, both running Windows Server 2000 with SP4 and SQL 2000 - 8.00.760 I have identical database being replicated, using push merge replication. One of the machine act as the publisher and distributor, and the other as the subscriber. Initial snapshot is working properly ...more >>

If I have a table on ServerA, and I want to do transactional replication to ServerB, and I set up a pull subscription on ServerB, is ServerB the distributor? I'm trying to balance the load (we want to offload ServerA as much as possible), and wonder how much (if anything) we save by doing th...more >>

I would like to ask is it possible to having deligate replication in SQL Server replication? e.g. Server1 replicates with Server2 and then Server2 replicates with Server3 Thanks ...more >>

I'm looking for a little help in preparing a disaster recovery staragey for merge replication. We are desigining a replication topology that includes publishers, named Republishers and several hundred anonymous merge subscribers. The "top tier" publisher will only talk to named subscribers...more >>

The title pretty much sums up the question: when I try to edit the table structure, i.e., add a field or change type from int to uniqueidentifier, the change is rejected with "cannot drop table" error. ...more >>

Can someone tell me whether using GUID's as identity keys is a good/bad idea to get around the problem of Identity Ranges for different subscribers (when using merge replication)? I am looking at replication for the first time as we are about to start a project where multiple remote sites w...more >>

Hi Friends, I have a db with more than 350 table, most of them have Relational Integrity with PK and FK we want to have this DB replication to another server. What are the potential problems and solutions? I had experienced problems and conflicts if db has Relational Integrity. Thanks in...more >>

We run some nightly processing, but we wait till some data has replicated. We query the MSdistribution_status view in the distribution database to determine if our data has been replicated. The query is: select * from distribution.dbo.MSdistribution_status s join pssi..sysarticles a on a....more >>

Hello, We have set up Merge replication, using sql 2000. We have one publisher and four subscribers. When setting up the articles on the publisher, we manually set an identity range for one of the tables. The range size at the publisher and the subscriber is set to 5000, and the assign n...more >>

Running Win2k & SQL 2k How do I remove orphaned subscriptions? I have several subscriptions that appear in the distribution agent of the publisher that do not exist on the subscriber. Is there an SP to remove these?? Is there a way I can do it manually? TIA, Larry......more >>

I am activating a replication of the transacional type with only one table. Everything enable normal, at the moment to pass the data appears the following message: String data, right truncation (Source: 172.18.7.22 (ODBC); Error number: 22001 -----------------------------------------------...more >>

I am setting up the replication for a newly installed second instance say inst2. While creating the publication, I got error 515: cannot insert the value NULL into column 'step_name', table 'msdb.dbo.sysjobsteps': column does not allow nulls. However, the first instance, inst1 which wa...more >>

I set up TR on table T1. Works fine. While it was running, I tried adding an article, mysp. I couldn't quite figure out what to do to send the initial snapshot of just mysp, while replication was already running for T1. Eventually I ... well, I lost track. I think I deleted the subscr...more >>

I am just beginning with transactional replication, and I have a publisher with a primary key on the identity column (UID), some data, then an adddate (varchar 8) column iwth ccyymmdd data in it. I want to replicate this table to a server based on the adddate value (all records pushed since a ...more >>

I have some rows I need to delete at the publisher but I don't want to replicate these deletes to the subscribers. Is there any easy way to do this? tia Tina ...more >>

I am working on replacing a server and at the same time am working on updating our DRP Plans. I have a SQL 2000 SP3 server that has 3 App databases. I know that the normal procedure would be: 1. set up OS/SP 2. Install SQL/SP 3. Install Patches/Updates 4. Restore Master/MSDB databases...more >>

I am currently attempting to replicate data from a SQL Server 2000 database to an Oracle database using transactional replication. All works fine with the exception that when I attempt to replicate data which contains double quotations, it is somehow stripped out by the time it reaches the sub...more >>

The -MetadataRetentionCleanup is missing from the merge agent profile on one of our SQL Server's. It is a SQL 2000 SP3 installation. Does anyone know how to get the option into the agent profile....more >>

Hi, I'm trying to resolve a merge replication conflict problem, and I'm not sure how to do it, additionally to this, I imagine that this is a very common problem, so, some expert may point me on the right direction. I have 3 tables that needs to be replicated, 1 publisher, 10 anonymous subs...more >>

The excerpt below is taken from another site. How do I check/set the "automatic Retention" for a merge replication publication? From bol: It should be used only in replication topologies that include servers running versions of SQL Server prior to SQL Server 2000 Service Pack 1. Topologi...more >>

When adding a database to publications, the process gets stuck on the first article of the database. This only happens on databases that were previously replicated, others run through without the slightest problem. We also checked the transactions issued with sp_who2 / trace, it looks like the...more >>

When adding a databases to publications, the process gets stuck / goes into endless loop on the first article of the database. This only happens on databases that were previously replicated, others run through without the slightest problem. We also checked the transactions issued with sp_who2 ...more >>

I’m just curious that what happens when my merged replication fail half way due to the network. Is all replicated data rolled back?...more >>

Using SQL CE merge replication, we've seen the following error during bi-directional sync (the upload only phase of sync, which we perform immediately prior to the bi-directional phase, succeeds). Users have sync'd successfully before this error occurs. -Error Code: 80040E35 Message : Nativ...more >>

1. Trying to detach in EM but get message 'can't detach while db being replicated'. OK button is disabled. 2. Replication has been disabled vua Enterprise manager and sp_removedbreplication. 3. I know that at one time a user had tried unsuccessfullt to set up replication between this db and a ...more >>

I have several snapshot publications. These publications generate a new snapshot every day at 03:00. I noticed that the snapshot folder at: \\servername\sharename\unc\publication_name has many snapshots in the folder (i.e. one for each day at 03:00). How/where do I go to configure how "long...more >>

Can someone give this newbie a script that can do the following from a SQL 2000 sever. It appear that we are pushing database replication to a machine called Prod2 from SQL 2000 server Prod1 I need a script that will allow me to drop a publication/subscription and articles from Prod1 so th...more >>

Does anyone know the resolution to this problem? Error: 14151 Severity: 18 Database: distribution Message: Error: 14151, Severity: 18, State: 1 Replication-agentclassname: agent AXW1CLDB01-paytrax-paytrax-Axe1cldb01-1 failed. The process could not log conflict information. ...more >>

I have two machines, both running Windows Server 2003 and SQL 2000. I have a database with two tables. A homemade process does a bulk insert of data every five minutes. This database is less than 1 GB. One server is the publisher and distributer, the other is the subscriber and we use me...more >>

I have 1 table with 78 million rows that I have setup for snapshot replication. I only move the previous days data to the subscriber. Recently, I have had timeouts while creating the snapshot. I have increased my querytimeout from 600 to 1200, to alleviate this issue. Hopefully that will work...more >>

Hi I'm setting a publication with the create publication wizard. When I specify articles, I set "article defaults" in order to manage owner other than "dbo", and I set article properties to set "Identity range" for each table (default values). When I finish with the wizard, I get an erro...more >>

Is there a way that I can programatically disable a publication from replicating if publication conflicts exists? My intent is to check is there is publications conflicts for the pub and prevent it from replicating on its next scheduled replication if previous conflicts exist. ...more >>

Placing relationships to the Not for Replication Option eliminates the relationship in the subscriber database. I created a brand new database in the subscriber that will contain data from a publisher , applied the initial snapshot, and all the foreign keys are set to the not for replication op...more >>

Where can I read about Subscription Databases (creating, attaching, pros, cons) in SQL 2000? TIA, Larry......more >>

Hi, I have installed sql server 2000 sp 3 on a publisher/distributor. I have about 6 merge replication configured whith pull subscription. Four of them are ok but one give me this error. The process could not deliver the snapshot to the Subscriber. (Source: Merge Replication Provider (Agent)...more >>

Getting the following error at the subscriber: "Could not apply snapshot via ftp because the Publication was not enabled for internet" Looked every where and can not find where you would enable a Publication for internet. I setup up several smaller Publication and do not have this problem...more >>

Hi,Friends We have found a merge replication in two domain with one anonimous subscriber. And we set the continuous replication. But the problem is that data changed on publisher can not replicate immediately to subscriber. Sometimes after 3 or 4 hours, sometimes after two days. And in hi...more >>

hi, can i prevent rowguid from coming up when my application runs a "select * from ..." query on a replicated table (similarly to rowid not coming up in oracle). ...more >>

Hi, I need only my publisher update the subscriber and changes on subscriber do not affect my data on publisher. Should I necessarily use Transactional or Merge can be used? Thanks in advance, Leila ...more >>

1. I need to upgrade to sp3a on a distributor that has about 40 publications to various subscribers. I will be going from sql2k rtm to sql2k sp3a. Are there any issues as far as replication goes patching from rtm to sp3a? I cannot afford to reinitilize any of these publications. 2...more >>

Runing SQL 2k, Win 2k We had to rebuild a server and when I attepmt to configure replication I receive the error.... Could not connect to server 'newSERVERNAME' because 'distributor_admin' is not defined as a remote login at the server. When I look at the Logins, 'distributor_admin' lo...more >>

I am doing merge replication to PocketPC devices using SSCE over the internet and I'm wondering if I can increase security by moving the distributor into the DMZ so that IIS will not need to connect all the way back into our internal network (where our SQL is). We are curently using standar...more >>

I had to restore one of the dbs which has replication setup with another SQL, my problem is that after restoring db I have lot of red "X"s on Publisher server, and I cannot get ride of those, what am trying to do is to clean this up and recreat replication but get following errors (one in the ...more >>

We are a software development company that is beginning to incorporate replication into two major projects. We would like to have someone help us with replication consulting/training/troubleshooting help. Does anyone know someone who can and would do this? Hillary? Paul? Others? Paul ...more >>

Hilary, is it delivered now?...more >>

I am having to add a new identity field to table. What I want to know is that in the replication setup I have do I need to set it to "not for replication". The replication configuration I have here is each overseas office acts as a publisher and the subscriber is a database back here at head ...more >>