Psst! Did you know DevelopmentNow is a mobile web site design agency?

Contact us for help mobilizing your site, or to sign up for our beta Mobile Web SDK!


Archived Months
April 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
October 2008


all groups > sql server replication > recent posts

RE: URGENT -- Disconnecting from Publisher.
Posted by Musawar at 1/28/2010 10:01:09 AM
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 >>

merge replication snapshot problem
Posted by Matic Ċ½eljko at 11/11/2009 7:48:08 AM
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 >>

Subscriber DB data gets invalid characters
Posted by IEL at 9/10/2009 2:07:39 AM
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 >>

RE: error message on publisher
Posted by Kevin at 8/13/2009 9:38:29 PM
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 >>

NEDD TO FIND ACTIVATION CODE FOR WINDOWS XP PROGRAM
Posted by MARY RINEARSON at 6/25/2009 11:49:14 AM
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 >>

RE: SQL2005 - Snapshot agent won't start
Posted by zx9hippo at 6/18/2009 2:28:51 PM
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 >>

What's the steps to apply MS SQL 2005 into a transaction recplication environment
Posted by KT Wang at 6/16/2009 11:27:57 AM
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 >>

RE: SQL 2K5 Custom Resolver (Business Logic Handler)
Posted by SQLUSER at 6/16/2009 10:10:17 AM
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 >>



The remote procedure call failed and did not execute - Urgent!
Posted by JimF at 5/21/2009 1:43:44 AM
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 >>

RE: Error 14151 on Queue Reader
Posted by ravendra from india at 2/27/2009 2:29:06 AM
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 >>

merge replication
Posted by Carl Janssen at 2/22/2009 10:55:56 AM
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 >>

syncronising between distributor and publisher
Posted by tshorolpa at 1/15/2009 1:51:01 AM
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 >>

RE: SQL Merge Replication Error
Posted by Sebastian at 11/30/2008 11:39:26 PM
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 >>

SQL Merge Replication Error
Posted by Tek_Timmons at 10/28/2008 12:16:08 PM
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 >>

Rename Server Used As A Pull Subscriber
Posted by Chuck at 10/23/2008 9:10:26 AM
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 >>

RE: replication triggers
Posted by Fernando at 10/16/2008 9:20:48 AM
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 >>

RE: replication triggers
Posted by Fernando at 10/16/2008 9:20:44 AM
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 >>

RE: URGENT-- Replication blown up.
Posted by Doug at 9/22/2008 12:14:45 PM
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 >>

Renaming replication jobs
Posted by Ryan at 8/20/2008 8:48:29 AM
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 >>

RE: Error 20026. The Publication does not exist.
Posted by kathi at 7/23/2008 6:39:58 AM
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 >>

RE: Error 20026. The Publication does not exist.
Posted by kathi at 7/23/2008 6:34:58 AM
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 >>

RE: aut-restart
Posted by Odie at 5/30/2008 11:08:58 PM
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 >>

RE: Show pending merge changes
Posted by Raju at 4/10/2008 12:14:43 AM
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 >>

RE: The process could not bulk copy out of table '[dbo].[syncobj_
Posted by Stefan at 3/12/2008 4:28:35 AM
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 >>

RE: syncobj_* views?
Posted by Bianca at 12/4/2007 8:02:00 PM
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 >>

Problems with SQL 2005 Merge Replication and blob, nvarchar(max), nchar(max), image objects .waiting for 10 mintues
Posted by SafetyMan from Louisiana at 11/30/2007 4:02:51 PM
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 >>

Re: aut-restart
Posted by Hilary Cotter at 11/3/2007 9:08:04 AM
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 >>

Re: Replication From 2005 to 7.0
Posted by Hilary Cotter at 11/3/2007 9:06:40 AM
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 >>

Re: Transactional Replication Distribution agent
Posted by Hilary Cotter at 11/3/2007 9:05:34 AM
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 >>

Re: Some tables not getting updated under merge replication
Posted by Hilary Cotter at 11/3/2007 8:59:02 AM
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 >>


DevelopmentNow Blog