I am importing some data into the subscriber using DTS packages and these data are not being replicated. Importing the same data into the same table using .Net code and datasets causes the data to be replicated properly. What would cause a DTS to NOT fire the triggers? Please help....more >>

I have setup merge replication environment among three servers having SQL Server 2000 . Lels suppose servers are A,B and C. Server A and Server C are publisher as well as subscriber to server B while Server B is subscriber and publisher to both Server A and Server C. Now Whenever a transaction i...more >>

I have a big problem with my Merged replications (80 laptops running SQL 2000) (Server is also SQL 2000 SP3) All was working well until friday. From this date all my agents give me the error : - Failed to enumerate changes in the filtered articles. Some time I also have some details : ...more >>

Hi, I have a database on a SQL Server 2000 that needs to be setup as merge replication to another SQL Server 2000 but the other server is from a customer so we setup a VPN between our networks and I can login and make queries on their server and they can also do the same on our server so the ...more >>

Is there a way to configure the replication agent to transfer the snapshot using PASV? Replication is merge pull....more >>

Can i replicate from SQL 2K SP3a publisher to SP4 subscribers ? Can i replicate from SQL 2K SP4 publisher to SP3a subscribers ? Or do I have to upgrade them all to SP4 ? What about replicating from SQL2K to SQL 2005 and vice versa ? Thanks ...more >>

I have a table with around 330 columns. I need only 140 odd columns to be replicated from this table. I do the below steps to setup the replication. 1. On the Create Publication wizard, I choose Transactional replication, choose the subscriber types and specify the article. 2. After giv...more >>

Hi all, I saw the tracking level as Column-Level tracking in the article properties of publication and I saw Conflict_type=1 in MSMerge_Conflicts_info table. Is there any common in both of these, I doubt the merging changes is set to Column-Level tracking and conflict_type s...more >>

Hello, Databases A and B are currently identical. When edits happen to B (which will be rare), I would like users to be able to visit a web page, press a button which synchronizes A to the changes on B. Can anyone advise on how to achieve this? Would it be necessary to set up some kind...more >>

Hello, I'm using SQL Server for Merge replication and I looking for a list o actions that require to delete a subsription and to recreate it Deleting a sub. implies to stop the production and some money loss :( For example, when modifying a publication table's structure (lik adding a colum...more >>

Please forgive me for being a little green on replication, I have not used MSSQL's (2000) replication capabilities yet but I'm trying solve a particular problem and I'm wondering if SQL Server's built-in replication will solve it. We have a database (SQL Server 2000) at location 1 within a cor...more >>

Hi All, I'm using RMO to generate the initial snapshot and all works well unless I try to present the user with some status in a winform application. The GenerateSnapshot method will proceed up until the point where it starts bulk copying data at which point I get the following error: ...more >>

I have just started setting up SQL Server 2005 Subscriptions for the first time and I already have a major issue (I have done hundreds of SQL 2000 merge setups). The problem that I am having is one of the Subscriptions didn't seem to process properly and now I have like 20 "Uninitialized Su...more >>

Hi, I have merge replication set up with two databases - one is the publisher and is setup on a server with broadband connection, the other is a subscriber on a Tablet machine (which uses a 3G/GPRS card and has an intermittent connection, which is why we chose merge rep). The publisher is t...more >>

Hi, I have on my Distributor a Red X On - Replication Monitor directory - Publishers - Agents and Subdirectory Snapshot Agent The error is This server has been disconnected. You must reconnect to perform this operation. The server might go down during the weekend because the job...more >>

Usually I use Enterprise Manager to remove the Merge Replication info before trying to drop a database. Now I used sp_dropmergepublication - sp_dropmergesubscription -sp_dropmergepullsubscription - sp_dropmergesubscription - sp_dropsubscriber - sp_replicationdboption - sp_dropdistributor ...more >>

Hi all, 1) I am currently deleting a publication of a rather large DB (approx 8 GB) during off hours. It is taking an incredibly long time (more than 1 hour already). Does anyone know why does SQL Server take such a long time just to delete a publication? And I already have remove all su...more >>

Hello, I have a merge publication on sql2005 and mobile subscribers. Here is the problem I encounter: the records inserted in tables on PPC side on synchronisation with the server gets inserted on server tables but are also deleted from PPC tables. This behavior appears after few synchr...more >>

This morning, my log reader agents failed. In the server log, I saw the following messages: SQL Server Assertion: File: <logscan.cpp>, line=1985 Failed Assertion = 'startLSN >= m_curLSN'. ..... SQL Server Assertion: File: <logscan.cpp>, line=2223 Failed Assertion = 'm_noOfScAlloc == 0'. ...more >>

We replicate a 100GB database across the world. Our Wan Pipe is 2Gb/s. A snapshot results in about 30GB of snapshot data (schema and data), since this would take many days to initialize the subscriber, we use the backup & restore (no sync) initialization method. Backing up, rar-ing the database...more >>

We have a SQL Server publisher at our office that publishes data (transactional, daily at end of business) up a 10mb to a SQL Server subscriber at our website location that has access to 100mb of bandwidth. We are considering then turning that subscriber into a publisher as well to onward pu...more >>