Hi there, I hadn't heard of Merge Replication more than a week ago, so my head's spinning a bit. :) It sounds like it is what I'll need, but I'm wondering if things can be conditionally replicated... The program I'll be writing is for people at forest fires to keep track of expenses relat...more >>

Hi everyone need some help solving some replication problems I have an acess database that has a front end and a back end I have replicas of the back end running on PC that are not in a network - every 2 days they are sync. with the main replica to update I now want to have them do the sync. th...more >>

Somebody has strong scripts to test replication? Thanks....more >>

I need to add a new article to a publication that already has remote subscribers. I'd like to add the article and not have to reinit all the subscribers. Can I just run sp_addmergearticle? Thanks Tina ...more >>

Folks.. I have a client that is running MS Access 2002 for 10 people out in the field. The client wants to be able to replicate the data from MS Access 2002 to the SQL Server 2000. In addition, the client wants to have each field person only work on their own specific data set during the replica...more >>

It seems I can't figure out how to have two tables, say integer columns named A, B, and C, with a rowguid column. I want that table structure on my subscriber (A, B, C, rowguid) but I only want to replicate data from columns A and B. As it stands, replication tries to create it on the subscr...more >>

Hi all, I have a strange error in snapshot agent. When I run snapshot agent the agent is prepearing tables and in moment of prepearing one of the tables I receve error with details: CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID 5. Most significant primary key...more >>

replication type merge suscription two(a-b) function suscription (a) not function suscription (b) What this is the problem !! Help error: replication merge not put instantaneous time out thanks! ...more >>

I have a few tables that I need to replicate that don't have a PK. And since these tables are a part of a 3rd party app, I can't add one. While I'm confident I could add an identity col and they'd never know, my concern is that if they upgrade the app, I might lose the PK. I have 2 questions...more >>

Paul, Thanks for your reply. My distribution agents schedule is set to run at 7:00 am everyday (similar to my snapshot agent). I found that the distribution agent gave me an error and the details are as follows: Error msg: The process could not access database 'LETS30_Repl' on server 'FT...more >>

I setup replication between two servers in SQL 2000 and was working fine until one of our DBA's in order to help another user created link server to our distributor and since then I am getting this message and can not drop the subscription or start it again Any help appreciate Server name is not e...more >>

Hello, I am trying to perform 2 way replication in SQL 2000. SERVERA = OrdersTable -> I want data to replicate to this server from SERVERB on UPDATE only. SERVERB = OrdersTable -> I want data to replicate to this server from SERVERA on INSERT only. This is what I have done. I created ...more >>

I 've changed logon account for SQLAgent service and getting error message 14151 for distribution agent. Any ideas? Thanks,MILAN...more >>

I need to import data from an as400 database, what is the best way to do this? Regards, Sean Gahan ...more >>

Hi! I've got the following error, while trying to change schema on published DB: 21260 16 Schema replication failed because database '%s' on server '%s' is not the original Publisher of table '%s'. Please tell me what I have to do, to be able to change schema? Thanks. Best regard...more >>

I have merge replication set up on several database tables. I was reading about using sp_repladdcolumn and sp_repldropcolumn to make modification to the schema since it cannot be done directly with the alter table command. However, I cannot find either of these store procedures in the list for...more >>

I am trying to add a server managed ranged Identity column to an existing table in my database and then have SQL Server provide the management of subscribers ranges. I have had success with this using a test database (a book walk-though example) but now I want to add this to a real table in my...more >>

No luck. I tried as suggested but still get no love. Exact same issue. Additional info: both servers are in a workgroup not on a domain. Here is the output from the copy job as seen in the job history: The job succeeded. The Job was invoked by Schedule 100 (Schedule 1). The last step to...more >>

Hi I have Merge replication on SQL 2000 since last 6 months Recently I have notice that process is blocing other users and than timeouts on its own. Query Timeout is 600 This started recently and I'm trying to track this down. Any clue or suggestion to this problem I have Thank Nilay...more >>

Hi, We have an SQL server (lets call it FTANT001) and a datatbase (lets say LETS30). I want to replicate the database in the same server under the name LETS30_Repl. Naturally the publisher, distributer and subscriber is the same server FTANT001. I am susing a 'snapshot agent' to replica...more >>

Hola colegas, tengo un replicación de tipo Mezcla(Merge) con 2 suscriptores de tipo extracción(PULL) en Microsoft Sql Server 7.0 estaba trabajando muy bien hasta que incorpore un nuevo campo y sincronice las bases. El suscriptor no pudo comunicarse con el publicar y mostraba Error : tiempo de es...more >>

Hello, Can anyone help me with a Queued Transaction thats failing? I just set this up to do a snapshot and queued tranactional rep. The snapshot works great the queued part brings the error (last command) \\IMYSERVER\Replication\unc\MyDirectory\20040527160853 \myfile_0.sql. I've checke...more >>

I'm using transactional replication with queued updatable subscribers. My reason for doing this is that I want to be able to update the subscribers in case they lose network connection to the publisher. Everything worked fine in the begining but as our product has evolved the publication h...more >>

We have a T-SQL script that enables replication on a server, creates a publication on that server, and pushes a subscription. We also have a script that deletes the subscription and publication and disables replication. The problem is that, in EM, when the deletion script is run, there is still in...more >>

I am new in replication, but really need your help... My replication is simple but I am struggling Set u -Win 2000 server with sql20 - 2 server, non trusted domain and hapy to use sql authentication - Both server have the same sqlexec user and impersonating the sqlserver agen - I am trying a s...more >>

Error message for a Distribution Agent: "Could not find stored procedure 'sp_MSins_<table_name>'." ...more >>

Hello i have problem with merge replication agent. the agent stops with error message "Der Prozess konnte die Änderungen auf 'Subscriber' nicht aufzählen. "The process could not enumerate changes at the 'Subscriber'. Repl Agent Status: Percent Complete: Category:NUL Source: Mergereplika...more >>

I have a replication setup running on 2 Win2K Server PCs with SQL Server 2000. Both the PCs have a common DB installed on them. The setup takes care of starting one PC as primary and other as backup. It also starts the SQL replication (transactional), where both the PCs are configured ...more >>

I have set up log shipping between 2 servers but cant get it to function correctly. Everything seems to be fine, the backup job happens, dumping the transaction log to the network share on the primary server(also the monitoring server). The copy job runs and completes in 1 second or less, but d...more >>

Can someone give me an example and basic explanation of sp_repldone. BOL is getting me down ;-) -- Duncan ...more >>

Hello! Hope everybody is doing OK. I have a question. I don't know why replication suddlently stopped. In this case how can I check what was the real problem. I started synchronizing and it started but I still don't know what was the cause. Thank you in advance Jennyfer ...more >>

Sql 2000, Enterprise Edition, Windows 2003 Basically what I did was; 1. Alter tables with identity columns =3D Not For Replication 2. Changed all triggers =3D Not for Replication 3. Added PK's to tables that did not have them as follows; Alter table ap_payaud_tbl=20 Add pk_col int...more >>

Hi NG We are currently implementing a solution which requires SQL 2000 replication. This is done via ISDN dial-up. The Publisher is on a Win2003 box with SQL2000(SP3a). There are 4 subsrciptions located on WinXP machines with MSDE2000 (SP3). A 5th subscription is located on a Win2K Se...more >>

Hello I'm writing a custom COM conflict resolver to handle replication conflicts I'm having problems with handling a conflict caused by the violation of a foreign key constraint Situation Publisher deletes item Concurrently the subsriber creates item Y with a foreign key to item My goal ...more >>

Dear All I successfully put in place a high availabiilty replication server using Snapshot and Transaction Repliction (thanks to those here who helped). We have a number of IDENTITY columns we use for primary keys that were set to 'Not for Replication' So we turned off our production ...more >>

Hi Kees, I checked your replication logic, couldn't figure out why the replication behaves like that. So I setup a merge replication to test, using one table: 1. Create the merge table: create table T3 (c1 int, c2 int, c3 char(8), c4 int) insert T3 values (1, 1, 'one', 0) 2. Checke...more >>

How do I delete duplicate records in a table which doesnot have any identity colum in a single query pls help...more >>

I realize this issue has been posted MILLIONS of times, and believe me I have read many of them and find no clear explanation as to the cause or how to fix it. I have a table I created with three primary key fields which I am going to insert data into from my temp table. My temp table has no prima...more >>

Hello, I'm wondering if there is a way to replicate the contents of a view to a table using SQL Server 2000 and MSDE. Currently we use Remote Data Access (RDA) with SQL CE on our PocketPC-based application. We need similar functionality to get data into MSDE. We are only interested in read...more >>

Hello! Hope everybody is doing OK. I have a question. I don't know why replication suddlently stopped. In this case how can I check what was the real problem. I started synchronizing and it started but I still don't know what was the cause. Thank you in advance ...more >>

I have merge replication setup on SQL 2000. I am getting the following error during when the snapshot runs: Error: 7102, Severity: 20, State: 7 SQL Server Internal Error. Text manager cannot continue with current statement.. The only KB article I can find does not seem to be relevent. ...more >>

I am attempting to replicate an accounting database to another database on a seperate server. I get the following error "Error 15006: Invalid characters in object so therefore, it can not creat the article. How can I fix this issue? ...more >>

Hi I'm having a problem with replication The situation is the following Operating System of the server: Win server 200 Database: SQL 200 Subscribers: SQLCE in PDA's HP555 Number of subscribers: 2 Subscription: Dail Somme of the subscribers (PDA) take some a long time to process all the info...more >>

Hi I am new to Sql Server I have a development done in MS Access, it is running on a server, splitted BE / FE and replications for we have 5 laptops that run and update the DB offline and then sync to the LAN, when they return to headquaters I want to migrate this to them syncing through the int...more >>

Is it possible to restoring the master db ?? This is to restore the merge agents settings, without creating the merge agents again? If any one got an answer for this please reply asap. ...more >>

Hi, In my merge replication scenario I use Push subscriptions. The distributor is SQL server 2000 Sp3a, and subscribers are MSDE SP3a. Everything works fine but recently merge agents started to "hang" reporting no errors at random phases of replication session. They stop sending or receivin...more >>

After replication, my log has grown upto 300 MB and my Database size is of 20 MB.I want to truncate my LOG.Please let me know how to do it Help Neede Thanks & Regard Asif ...more >>

I just recovered a broken server with Windows 2000 server and Sql Server 2000. I had to format the hard disk and I recovered the database files (.MDF and ..LDF) from console, because the Windows installation was lost. There was a replication (the server was a subscriber) so now, after I attache...more >>

Hi everyone, I'm currently running sql2k sp3 on win2k3. It's a clustered server and running merge replication with another clustered server offsite. Right now our snapshots are taking too long (almost 8 hrs, database is about 180 GB). The snapshot folder is on a local drive so it should ...more >>

I am trying to get my log files to reduce in size, but when I run DBCC LOGINFO (MPlus) I get 491 rows with status =2 so when I go to shrink the logfile after a backup (BACKUP LOG MPlus WITH TRUNCATE_ONLY) I get "Ensure the Log Reader Agent is running or use sp_repldone to mark transactions as di...more >>