is it possible to trap a replication complete event on a per client basis? i need to notify a client to refresh a dataset when the replication has been completed. is there a way to do this? if so, is there a doc or an example that explains how? thanks m ...more >>

Hi all, Currently I need to perform in C# merge publication between SQL Server 2000 and Microsoft Access 2000. I tried using Jet Object Replication COM to perform this but encounter the following error. Any advice or alternative solution is greatly appreciated. Thanks. Rgds, Winston ...more >>

Hi there, I am looking at setting up a solution that relies on replication of data to many publications. I believe what I need is merge replication. In this scenario, many companies will receive data from the master publication but each company should ONLY receive information for their concern...more >>

I have an existing merge publication and would like to convert it to transactional with queued updates, because I think that the transactional is probably more robust. Queued updating wasn't available in earlier versions of SQL Server (v6.5 as I recall) when we first set up our replication. We ...more >>

hi is it possible to mapp columns with different names between publisher and subscriber? something like this server A (publisher, distributor) table test with columns (column1, column2, column3) server B (subscriber) table test with columns (column1, column2, column_other) i'm trying to ...more >>

Hi, We are attempting to setup Pull Merge replication between two SQL Server (SQL 2K sp3a, Windows Authentication) machines in different domains. We have been able to get Pull Merge replication to work within the same domain. While we are running Win2k on both machines, two one way trusts ...more >>

Hi, we are using merge replication between remote sites and our central office. couple months ago we had a situation where we had to insert some records and update other records with these inserted records and then delete the inserted records. Then we reinserted these records again with...more >>

It has been suggested that we consider how to replicate our production server to a remote site that does not have a dedicated connection to our production environment. Any and all suggestions are appreciated. TIA Michael MacGregor Database Architect SalesDriver ...more >>

Hi, I configured a merge replication with pull subscription. I need to do some changes on the table structure so, i delete the replication, do the changes and configure the replication again. I saw that every time the publication is configured it creates some conflict tables but don´t delet...more >>

The distribution server for my publisher is a live server, and the publisher is a test server that I wish to make it's own distributor. Whenever I try to select it as it's own distributor, I get an error that "distributor_admin" is not a local user. How do I go about fixing this Thanks for your ...more >>

I just inherited an application using merge replication to pull information from the database server when the users activates the synchronization process. When the user is connected to the network, can I push the subscription to the them from the server instead of having them initiate the ...more >>

I had perfectly fine replication environment where I was running merge replication between one publisher/distributor and two pull subscriptions. After making some change to the schema of the publication I now get the following error My initial thought was that this was a permissions problem when t...more >>

Hi I have a very interesting situation with my replication. Replication works great if I leave opened Enterprise Manager, but when I close it, replication and SQL server does not work any more. If I made a "mistake" and close EM, that the next morning SQL server does not respond even if I ...more >>

** This is re-posted from the private MVP newsgroup following no response. Hopefully someone's got some experiences with Oracle -> SQL Server replication and can help me out here (: ** I've been asked for an opinion on how to best perform Oracle -> SQL Server 2K replication but have to admit...more >>

Hi I was synchronizing two SQL Server 2k (SP3) using merge replication for the last 4 months. There was an error in one partiucular table at the publisher because of which synchronization had stopped for around 14-18 hours between these two servers. I fixed this table using the DBCC checktable wit...more >>

Is it good to maintain article by article in different subscription? The purpose for my action is to add and delete article without affecting the other subscriptions?...more >>

We have the following scanario. Publisher is SQL 2k SP2, Subscribers are SQL CE 1.1, using merge replication. Everything is fine, until we start SQL Profiler on the Publisher Database. If the Profiler is running then replication takes 2-3 attempts, failing between times with server errors....more >>

I am running Win 2K & SQL 2K. I had 3 dBs that are showing suspect in Enterprise Manager. I detached, then attached it, and it came back online. The other two dBs are distribution & StoreMain. I am unable to detach StoreMain or distribution because of replication. Some of the backups...more >>

Can I define an alternate snapshot file location for a push subscriber How ...more >>

Dear Friends I am face the following problem. The process could not deliver update(s) at the 'Subscriber'. The replication is falling please help me. Best regards sharad...more >>

Hello. I have a table which I replicate to server B. Does it pose any problems if I update the table Server B, then replication overlays the rows a minute later? Someone told me that replicated tables keep track of the last date/time the row was updated, but I thought that was only the publ...more >>

Hello guys Does anybody know how can i create a relationship between tables in different databases? Does SQL Server supports this kind of operation The main problem is that i have some data that is shared between different databases and i'd like to have some kind of referencial integrity in the ...more >>

In EM, i expand the Publications node in the publication tree, select the desired publication, and on the left side i delete the subscription. EM asks me if I want to delete subscription at the subscriber. I choose yes, and then i hit the router with my leg, and the EM says "can't connect to the ...more >>

Hello! I've got quite fu**ed up merge replication still sitting on one DB and I cannot remove it. When I run sp_removedbreplication db_name I get an error that it cannot delete conflict table. Now, as I was checking how to correct this error, I see that sp_MSarticlecleanup is trying to delete ...more >>

Hi, I'm using push transactional repplication over Internet from MS SQL 2000 to another MS SQL 2000 server. I would like to achieve minimal possible latency (who wouldn't :-) Is it sufficient to choose option "Continuous ..." in configuration wizard for replication or there are some additiona...more >>

Hi, I have applications using Sql Server 2000 database at a primary location. As a disaster recovery i.e if Sql server at the primary location fails , i have setup another setup with Sqlserver 2000 and applications at secondary location. I want to know what is best option for disaster recovery ...more >>

We have a system that uses SQL2000 (SP2) with the main database in our main location. We have been working on setting up replication to a secondary location, and believe we have solved the relevant issues there. We have just been asked (read told) to set up replication to another server that w...more >>

Hello I am running SQL2000 SP3. I just set up a merge replication. I build the initial snapshot en brought it to the subscriber with a pull subscription. The publication makes use of some filtering mechanisms After that I delete some records in the publication database. When I try to synchornize...more >>