Hi, I have Merge Replication ( Articles x,y) with Publications at 4 Sites and a Central Subscriber. All the Merge Agents are running with property -exchangetype 2 parameter Article x have 12 triggers (4 for insert, 4 delete and 4 updates) which looks OK ( 1 set for each publication) but ...more >>

Upsized an Access .MDB and Published successfully, EXCEPT forgot to make visible the sysobjects, so two Tables each have four Columns named: Expr1, Expr2, Expr3, Expr4. When I try to rename them with SSEM in the SQL Database, I get errors like this: 'tblNoteAdmit' table - Unable to rename ...more >>

Hi All, From time to time (about once a day, and it lasted about 2 minutes), the following error happened: DESCRIPTION: Error: 14151, Severity: 18, State: 1 Replication-Replication Transaction Queue Reader Subsystem: agent [MYDB].12 failed. Server: MYDBSERVER, Database MYDB: ODBC Error...more >>

I have a table that used to be in a merge replication. How ever it is not being replicated any more, I can't drop it because it thinks it is been replicated. How can I drop it? Thanks a lot, Lina...more >>

I have a merge sinchronization working just fine. And I have a table sinchronizing a long time ago without data because i was not using it yet. No that I have decided to use it, it always said that I can't insert Null in the rouguid column. How can I fix it? Thanks a lot!...more >>

I'm new to replication, but have a challenging requirement... I have multiple MSDE 2K instances that will be used by a surveying crew that may be distributed across many miles - sometimes in jungle or desert environments where they never even see each other. All/any data in any instance ...more >>

I was wondering if any has taken the Microsoft course on Replication? I need to give a two day tutorial to some of the poeple I work with in Operations on Replication and came across the course outline for this class. The outline was perfect - I could eliminate some of the modules (merge re...more >>

I have make a transactional replication beteween 2 pc. I set up continuosly update from publisher to subscriber and from subscriber to publisher. The subscription method is push. When I make a upadate on a record on publisher I have the update also on the subscriber after few second and this i...more >>

Hi all, I'm using SQL Server ActiveX replication controls for synchronizing programatically a snapshot type publication to an anonymous subscriber. The subscriber is on a laptop and the idea is when this si connected to the network, and the user wish, it can hit a button on a simple Visual ...more >>

We have a subscriber that want's to change the dbo password for the replication user. Will this effect current publications to that subscriber? tia -comb...more >>

hi all...new to replication and 1st post here ....looking to replicate our database and having trouble with one table. i recreated the table in northwind to isolate it from the rest of the DB tables in the app. Same result. Table name: REASON COLUMNS IN TABLE: REA...more >>

This is probably a newbie question but I was wondering if there is a way to setup the initial snapshot between two databases, that are the exact same database, and merge the data between the two without losing or overwriting any data? It seems that "Merge" is the way to go however I either get...more >>

I have been running ftp replication for some time and recently thousands of records have gone AWOL from the master database. The majority of the records appear to be PractiseAnswers which contains Practises answers to Questions (all uniqueidentifiers) i.e.: rowguid PractiseID QuestionID ...more >>

I have configured log shipping on SQL Server 2000, and all data is being restored correctly on destination servers within 30 minutes. The problem is the continuing failure of the Log Shipping Alert Job - Restore task. Every minute it records the error 14421 in the event log The log shippi...more >>

I have a customer application where I utilize merge replication between sqlserver2000 and pocketpc's that are running sqlserverce2.0 (vb.net 2003). It appears that the customer has some tables that they use to keep track of who modifies the data in certain tables. they want the same functionali...more >>

Hi all, I could REALLY use a hand with this one. Merge replication (DB authentication) over the internet using MSDE Subscribers (on XP) and a SQL2000 sp4 Publisher on windows server 2003 (w no domain conroller). Current development environment is on my home network. The current problem i...more >>

hi, Could anyone explain to me under the relationship property, what is the meaning of "Enforce relationship for replication"? I understand that the "Not for Replication" in Trigger is that the trigger won't get fired off if the data is Insert/Update/Delete during the replication process...more >>

Initially, when I started to setup replication I received the error message ~ "one or more articles are published ...", so I issued the following commands to remove replication settings from the DB: sp_configure 'allow',1 GO reconfigure with override GO USE ImageCraft GO sp_removedbrepl...more >>

hello all i have a huge problem. My server crashed i had to reinstall windows nt and sql server 6.5.my buckup is 2 weeks old and i dond want to lose my db, i have all the file when it crashed from the directory MSSQL. Is it possible to restore my db using the master.dat or onother file in the ...more >>

Dear friend: I got this error message inmediatly after to create a suscription for a publication. Violation of PRIMARY KEY constraint 'PK__@snapshot_seqnos__6B318B07'. Cannot insert duplicate key in object '#6A3D66CE'. Last Command = call sp_MSget_repl_commands(19, ?, 0, 7500000) Wha...more >>

I have a user that is complaining that replication is lagging by 10 minutes sometimes. I have two questions: 1. Is there anyway I can track latency to prove/disprove his statement? 2. Is there anyway to improve latency? I am running trans replication on SQLServer2000 using a push subscript...more >>

Hi, We're experiencing a problem with transaction replication on SP4. The snapshot is taken without any problems and applies, however, when it comes to processing the additional transactions which have taken place since the snaphot, the process starts processing in parrallel and blocks its...more >>

I have all the publishers on a emc san with 2gb fiber cards. My backups are all done across the san as well, so speed is very fast. However, I am running into contention backing up the databases that are publishing. Those db's are taking 8hr's + to backup when the non published db's are t...more >>

We followed the 33 page instructions about how to configure SQL replication, but we'd like to undo everything and stop replication. We can't find any instructions about how to do this. Can anyone tell us where to look?? Thank you!! ...more >>

All, I am trying to get a SQLExpress client to merge replicate with SQL Server 2005 April CTP. I am using RMO to create the subscription, register with the publisher, and initiate synchronization, however the examples in the SQLExpress BOL indicate I should use: mPullSub.SynchronizeWithJ...more >>

I am replicating via the sp_MS* procedures. Replication works fine for inserts where sp_MSins_<tablename> is executed, but I have errors when updating, since the same insert proc is called rather than the sp_MSupd_<tablename> proc. I have checked the article details many times. The system sh...more >>

I have setup a pull transactional replications which replicates every 24 hrs. Tables I am replicating has heavy transaction activity, like we make atleast 100 thousand transactions on those tables. When distributor agnt tries to run on schedule every day morning at 2:00 am , it just keeps o...more >>

We are using merge replication and for some reason the merge agent's history generally only shows 1 to 2 days worth of history. I have tried changing the filter to "All sessions" but all prior history seems to be purged. I have looked all over for a setting or something to allow you to set...more >>

Hi all, I have a question about scheduled jobs. Suppose the snapshot agent is scheduled to run at 01:00 at night but the computer was turned off when people left the office. Does the agent then run when/if the computer is turned on the next morning? - or does it only run if the computer...more >>

I have setup pull transactional replication with multiple publications and distribution agents. One of my distribution agent always says the following error-- -- Timeout expired (Source: ODBC SQL Server Driver (ODBC); Error number: S1T00) -- while other agents are executed just fine.. ...more >>

Hi, I am using transaction replication and the identity column is not included for replication. After creating the snapshot, i manually copying the data through stored procedure from publishing database to subscription database. Then,if we run the distribution agent,i am getting the follow...more >>

Is replication compatible on a 128 bit encryption system that runs SQL server 2005? Hari ...more >>

Dear Members I have a simple question, I am planning to configure replication to gather my branch office data at Centeral Server (Head office) , I have configured each branch office server as publisher and Corporate server as subscriber, We have 256 K DSL connection across branch offices, Data...more >>

I am running SP4 on server and MSDE's. Using Merge replication with anonymous pull subscriptions. BOL says merge_contents grows indefinately. In the How Replication Works article under the Merge Meta Data Cleanup section, it implies cleanup of this table would only happen manually and if yo...more >>

Hi Paul, I am running SP4 on server and MSDE's. Using Merge replication with anonymous pull subscriptions. This proc on your website, www.replicationanswers.com, is it correct to say this proc can only identify changes the first time after the merge_contents table has been emptied (initi...more >>

It looks like I will have to use this resolver. Does this take into consideration different time zones? If not, does anyone out there have a custom resolver that can work across time zones? Thanks, Buzz...more >>

We have a client that would like to have their (Remote) web server SQL2K instance set-up for 2-way replication against their internal private SQL2K instance (Local). The problem is their network security department won't allow *any* TCP/IP socket connections to be initiated from the Remote SQL2K...more >>

What is the "correct" way to ADD a Table to an Anonymous Merge Publication? How is it then propagated to the Subscribers? Using Query Analyzer, I successfully ran a script to Create the Table. I added it to the Publication (Show unpublished ...) and Reran the Snapshot Agent. The Snapshot po...more >>

I am developing an application that also follows the default scenario of a field salesforce that needs access to only their customer specific information. I am implementing the solution using merge replication. I have the merge replication defined and configured on my server, complete with r...more >>

sp_scriptexec, pro p[ropagate a script to merge subs... I've done this before, but I'm getting this error?? i check permissions & normal stuff... Server: Msg 21330, Level 16, State 1, Procedure sp_MScopyscriptfile, Line 31 Failed to create a sub-directory under the replication working direc...more >>

I have setup transaction replication using seperate server for distribution box. Server A - Publisher Server B - Distributor Server C - Subscriber Its a pull subscription I am testing several situations, what happens if 1. Distributor sql agent is stopped and started - I have don...more >>

I am in the process of drawing up the plan to reinstate a number subscriptions which where lost when a windows update disrupted our wan. The publications are still in place on the overseas servers, but I need to be able to create the subscription and to then be able to generate the snapshot, ...more >>

Hi Here's a little context before the actual question - I have two servers, both running IIS and SQL2K. Let's call the "Local" and "Remote". - Remote runs a web application that stores user data on the SQL2 instance, also running on Remote. - Local hosts another copy of the application, but ...more >>

I'm a little on the illiterate side on SQL, but I cannot seem to ge my subscription pushed. I'm not sure what details I need to provid to get help, so I'm having to do it in pieces as I find clues. Se the image below http://www.chuckchamblee.com/tcifiles/Image2.jp It shows as DEACTIVATED. How...more >>

I cannot seem to get my subscription to push. It's status is bein shown as "Never Started". How do I get this back in operation http://www.chuckchamblee.com/tcifiles/Image1.jp ...more >>

I'm having numerous problems getting a good snapshot and subsequentl pushing a subscription out. I'm thinking about just redoing the whol process. Is there a simple procedure for doing this? At this point I'll take even a complex procedure to do it. Maybe if I could jus redo my snapshot successf...more >>

I'm trying to get a successful subscription push going on my databas publisher after having to alter a couple of tables. After making m changes, I tried to start the snapshot agent. Normally, I see th snapshot being created, which takes a few moments. In this case, al I saw was the old snapshot,...more >>

I was just experimenting with something in replication and created a test database called "ReplicationTest" This is on a server that is currently a subscriber for other databases, but I thought I'd also be able to set up a publication from "ReplicationTest" Db. I tried to create a pub...more >>

I want to drop a table from some of my transactional publications. Can I just drop the article on the publisher and then be able to delete the table at the subscriber? Or do I have to drop the article and re-snapshot the subscriber?...more >>

I am using the SQL Server Personal edition in remote offices with 2 or 3 clients each to connect to our central office server running SQL Server Standard Edition. I want to use the personal edition because when I am using replication between each client and main office and the EM will be use...more >>