How did you eventually fix the problem? From http://www.developmentnow.com/g/114_2007_2_0_0_932423/URGENT--Disconnecting-from-Publisher-.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com/g/...more >>

Saddenly during generation of merge snapshot I get this error The process could not create file '\\Srvproduction\REPLDATA\unc\SRVPRODUCTION_nara97be_Puna replika\20091111162118\MSmerge_contents.bcp'. All file in snapshot is generated in folder including msmerge_content_xxxx for each article but af...more >>

With the merge replication setup, sometimes the subscriber DB data has invalid characters, where as the publisher data is fine. What can be the issue? From http://www.developmentnow.com/g/114_2006_9_8_0_0/sql-server-replication.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com...more >>

I've had this same problem, I tried updating 3 records on the publisher's table that's replicating out to multiple subscriptions, and uses column level conflict tracking. One record updated, the other two had this same error. I updated them on a subscriber and they worked fine, and now this erro...more >>

I BOUGHT A COMPUTER FROM EBAY, AND IT HAD WINDOWS XP ON IT. I HAD SOME PROBLEMS WITH IT, SO, LIKE AN IDIOT, I DID A SYSTEM RESTORE. I TOOK IT BACK TO WHEN THE RESTORE WAS LAST DONE. WHEN I TRY TO LOG BACK IN TO THE COMPUTER, IT KEEPS ASKING FOR THE PRODUCT KEY. I DO NOT KNOW WHERE TO FIND THIS I...more >>

I know this is an old thread, but I do not see a resolution so I will pass along the items I found: ** My setup is intended to be as secure as possible so using special accounts for different pieces is a must so I had issues as follows: - The replication folder I specified did not have permissions...more >>

I would like to apply MS SQL 2005 SP3 into a transaction replication environment. Do I need to stop replication before apply SP3 at publish side? From http://www.developmentnow.com/g/114_2005_5_0_0_0/sql-server-replication.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com/g/...more >>

THANKS From http://www.developmentnow.com/g/114_2006_5_0_0_763319/SQL-2K5-Custom-Resolver-Business-Logic-Handler.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com/g/...more >>

Hi All I am in desparate need of help, or shot, one of the two. I am at the finishing line of a project and now am a week late because of a replication error that has me totally stumped. I have set up replication between MSDE SP4 on local PC and MSDE SP4 on web server, on my Vista machine ...more >>

I am unable to configure tranctional replication with update S due to below error ============== SOFTENGE-R 2009-02-27 15:26:16.74 spid58 Error: 14151, Severity: 18, State: 1. 2009-02-27 15:26:16.74 spid58 Replication-Replication Transaction Queue Reader Subsystem: agent [SOFTEN...more >>

I had some serious troubles with our merge replication which worked fine for 1,5 years I have manually added data to a new copy of the data When I want to publish again My snapshot generator reports : dbo.MSmerge_identity_range_allocations table is gone from the distributor Any idea how I can ...more >>

HI everybody, i am using merge replication. my concept is that: a publisher publishes a file and then it synchronized with distributor in a schedule (publisher and distributor are in same server). Then Subscriber subscribes (Sync) from (with) distributor not publisher. I want distributor to a...more >>

Any news on this issue. I have exactly the same problem. From http://www.developmentnow.com/g/114_2008_10_0_0_1060542/SQL-Merge-Replication-Error.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com/g/...more >>

Hello, We had this merge replication configured on the database and a web server and it has been running fine for last few months. However yesterday, I installed SQL Compact Server Tools for 3.5 SP1 and after that I have been getting following error when I try to refresh my subscription: TITLE...more >>

I have two servers, SQL00 and SQL01B. I have both set up with pull subscriptions from SQL20. I want to remove SQL00, the current production server, from service and rename SQL01B to SQL00. Has anyone done this sort of thing or know if I should anticipate issues. My intention is to not have to re...more >>

I'm getting this same error and looking for solution. One of them showed me to trying to find duplicate GUID cols in the corresponding table generating the error. Will fetch some T-SQL code to try to accomplish that... hope it helps ya. From http://www.developmentnow.com/g/114_2005_5_0_0_526279/rep...more >>

I'm getting this same error and looking for solution. One of them showed me to trying to find duplicate GUID cols in the corresponding table generating the error. Will fetch some T-SQL code to try to accomplish that... hope it helps ya. From http://www.developmentnow.com/g/114_2005_5_0_0_526279/rep...more >>

I have the same issue From http://www.developmentnow.com/g/114_2006_5_0_0_762654/URGENT--Replication-blown-up-.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com/g/...more >>

In SQL 2005 I am renaming the jobs listed under SQL server agent that launch all of the replication tasks. Problem I'm running into is when I do this I am not able to access these jobs from the Replication Monitor. I right click the subscription and select View Details. Then select Action -> Merge A...more >>

I need to clarify my earlier explanation - I restored again, this time not using the 'keep_replication options' for the restore. Seem to correct the problem! From http://www.developmentnow.com/g/114_2008_7_0_0_442369/Error-20026-The-Publication-does-not-exist-.htm Posted via DevelopmentNow.com Gro...more >>

I restored the database in question and did not use the 'retain replication settings' on the restore panel. I refreshed the publications, and the replications references were gone!!! I did not find any reference to the publications in any of the distibution databases. Restore the database without th...more >>

I have the same problem with this. Mu merge replication does not re-start when the replication fails. Can you give me instrucation on how to create a 4th job in order to re-start my replication. From http://www.developmentnow.com/g/114_2007_11_0_0_1034992/aut-restart.htm Posted via DevelopmentNow...more >>

This stored procedure does not work, if the merge agent has started and failed to synchronize (may be due to a network issue). From http://www.developmentnow.com/g/114_2006_5_0_0_762643/Show-pending-merge-changes.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com...more >>

I just got exactly the same problem here. did (in the meantime) anyone find a solution for the problem? From http://www.developmentnow.com/g/114_2004_9_0_0_446119/The-process-could-not-bulk-copy-out-of-table-dbo-syncobj-.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com...more >>

Hello, i was searching information about the syncobj* views. Do they always need to be under the public role? or can we assign these views to specific users and roles. Thank you very much. From http://www.developmentnow.com/g/114_2004_1_0_0_443938/syncobj-views.htm Posted via DevelopmentNow.com...more >>

SUMMARY: I have a table which is about 11GB in size, This table contains 3 fields. One of the fields contains a ntext() data type. The total number of records is about 400,000. This table replicates fine when it is over a very fast gigabit(Gb) network or even a 10/100 link(100 mbs). But once I ...more >>

I schedule the agent to run every 5 minutes. If this does not work for you, you can have a 4 job step so if job step 3 fails job step 4 will run. It will have a waitfor delay for 5 minutes and then loop back to job step 1. -- RelevantNoise.com - dedicated to mining blogs for business intell...more >>

In SSMS (SQL Server 2005 Enterprise Manager) register your SQL 7 server. You should be able to create your subscription now. -- RelevantNoise.com - dedicated to mining blogs for business intelligence. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking ...more >>

There is a parameter on sp_update_jobstep called retry_attempts. You can also find it by right clicking on the distribution agent, and selecting agent properties, steps, and double clicking on the run agent step, click on advanced and you will find them there. -- RelevantNoise.com - dedic...more >>

These tables should be getting updated. Check the conflict viewer to see if there are any conflicts there. -- RelevantNoise.com - dedicated to mining blogs for business intelligence. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on I...more >>