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

I want to replicate data via Internet using FTP Server, i have SQL 2K with SP3. i set up client network as - Server alias: my local server's nam - Server Name: ip address on interne - Network libraries: TCP/I - Port : 143 But i connect using Enterprise Manage to SQL Server then it errors: A ...more >>

Is it true that using date fields in tables being replicated is not recommended? If true, why? Thanks Emma ...more >>

Hi. I've configured replication between 2 SQL2K (installed on 2 domain controllers of the same domain). My plan was to have the posibility to change data on both sides, changes being replicated even from publisher to subscriber or viceversa. The subscription is a push one. Unfortunatel...more >>

I have tried many times to make a user to run jobs rather than run it using sa, where it gets tough is that the job is a repl-merge job, which needs the proxy account. So I made one, the local admin account who also a SQL Server sys admin. When I run the job using the 'userJob' that I mad...more >>

I am using merge replication with row filtering to limit replication of a table for the past 10 days of data. The problem is that I want the subscribers to automatically remove the data that is older than 10 days after the replication is done (assume that the table has a date field). Question...more >>

Hi, I need to add a new column to a table that is an article in a merge replication. I know how to do that in enterprise manager, but i need to add this new column in the table primary key. I try to do it but it seem that i have to remove the replication, do the changes and then configure ...more >>

I've been deploying/working with replication on a Windows Workgroup. I've created an account with administrative rights. On all my machines I log onto Windows with this account and it is also the account I have designated for replication as the Startup Service Account for SQL Server. Must I ...more >>

Hi I have transaction replication setup and the initial snap shot works fine. However after that updates are giving me the above error. Any help would be appreciated. Thanks Jeff...more >>

I am currently testing queued transactional replication using the Northwind database in SQL 2000. The Publisher and Distributor are on the server "main" and the Subscriber is on the server "backup". Everything is testing fine when I make changes, pull the network plug, restart the subscriber, ...more >>

I am using SQL SERVER log shipping to maintain 7 warm standby databases on a SQL SERVER located at a different location. The network between the 2 facilities has plenty of bandwidth. I am finding that the SQL SERVER agent job created by the maintenance plan to restore the logs on the sec...more >>

Hi, Is it possible to move all replication objects from the old server to a new server without recreating any of them?.. we are in the process of moving existing production SQL server to a new machine (which is the replacement for the old server with the same computer name).. according t...more >>

I have multiple tables with identity column replicated (merge replication) from Server A to Server B. During the initial setup, I specified that sql agent manages the identity columns automatically and runs in continuous mode. But a while, I got identity error and I had to stop the agent, ru...more >>

I'm setting up merge replication between a couple of SQL 2000 servers using DMO and want to use the automatic rather than scheduled option - which EM lets you set when you configure it manually. However, I cant see in DMO what setting I have to make - even when dumping the properties of an EM ...more >>

I have a field in a table that contains date data in the following format: 20040301 what is the best, low impact method for converting this to a useable date field? ...more >>

I've notice that when I disable replication the rowguide column remains on each table. Is there an easy way to remove it? ...more >>

All- Is their a utility that does log shipping? Maybe something in the SQL 2000 Resource Kit? Or do I have to upgrade to the Enterprise Edition from my current Standard? Also, where do I find/install the SQL 2000 Resource Kit? Thanks, DH...more >>

Hi everyone, We are trying to implement merge replication using a central subscriber model. When testing this out on 4 test machines, everything seemed fine. Now, we are running a live test alongside our old system. So far we have the central subscriber up and running and one publisher. The ce...more >>

Hi, we have developed an application using transactional replication, with several publication servers (push) and a distribution server (which is the only subscriber too). It seems to work fine. Now we would "protect" the distribution/subscriber server by using a standby server (note: only th...more >>

Having an anonymous pull subscription over Internet using FTP, the ActiveX control at subscriber give me the following error. The file exists and can be browsed and opened from subscriber location. Thanks for any ideea. Renato The schema script '\\CHRIS900\ReplData\ftp\CHRIS900_Stago_Stago...more >>

I'm using scheduled merge replication with SQL server agent job in mode "Inperosnate SQL server acount". I have problem with Windows synhronize manager, because it don't support this mode, and it always ask for supplaying SQL acount before replication. I need to use Synhronize manager on disco...more >>

Hi, We are having a problem getting replication to work consistantly. The problem is during snapshot replication and is initially at the point of running the snapshot. The error we get is "Attempt to access invalid address. The step failed." We are running Windows 2000 server SP3 and SQL Se...more >>

I'm not a SQL person but need to know if SQL2K can cross- replicate to SQL server machines? In other words, SQLSERVER1 publishes TABLE1 to SQLSERVER2 SQLSERVER2 publishes TABLE1 to SQLSERVER1 If this is a supportable configuration, how does SQL prevent playback of articles that it received...more >>