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 >>