I am trying to delete an obsolete subscription database. The publication database (and in fact the server) no longer exist but nobody bothered to drop the old publication/subscription before decommissioning the server. Now I cannot delete the database because the subscriber server thinks it is s...more >>

We will be deploying an application to several hundred remote sites which will be using MSDE. Each week the remote sites are required to replicate their sales data to a central sql server. At the same time I need to push new pricing to the remote sites MSDE database. I'm thinking that mer...more >>

Hi, We're running a test environment for replication on two Windows 200 servers with sp4 applied. SQL server 2000 has sp1 applied and w cannot go beyond this or the third party app we're testing breaks. Server A is the distributor and has a pull subscription to Server -publisher. On a f...more >>

I know how to generate replication scripts using the Generate SQL Script option by right-clicking the replication folder. But how do I generate a script when a publication is already created and an article published for replication has been changed with additional columns. I would like to generate...more >>

I have one database with 3 published tables, some columns for each of that 3 tables are included in replication. One table have static filter (row filtering). Replication type is merge, retention policy is "subscription never expired" (meta data not cleanable). Client side is IPack with SQLServe...more >>

I have been installing and administering this type of replication for sometime now and have never encountered the following logreader error. By the way, the pub server was using SQL2K SP3 and the sub server was using SQL2K(RTM) when the initial replication install was performed yesterday. I hav...more >>

I have a client that attempted (without success, but that is a different story) to configure replication. The additional fields created by replication now have caused a migration procedure from the DB application vendor to fail. This client is now in a quandry where the replication doesn't work a...more >>

Hi , I have a very strange problem here . we have 2 servers, one as publisher and another one as distributor and subscriber. last night logreader crashed suddenly with such an error msg: An error occurred while processing the log for database 'Poker01'. (Source: PAPDB (Data source); Error number: ...more >>

I have a SQL 2000 server running on windows 2000 server. I have a quote program that our salesman use developed with Microsoft Access 2000. I want the salesman to be able to connect to the network and have their quote information replicated to our server and if possible updates from the ...more >>

Is it possible to create a 2nd distribution agent that runs between the same set of servers as the first distribution agent? I would like to run one agent continuously, and the other once an hour. I only want to have one publication in each. I see there is a stored proc called 'distribution.d...more >>

I am getting the error message -=20 "Cannot use empty object or column names. Use a single space if = necessary." when replicating. I am using a "Push" from one server to another and = the replication works fine until this message comes up and it stops. How = do I find out what table is c...more >>

When I try to start the log reader agent, I get the following error The license for this installation of SQL Server does not permit Log Reader Agent to run at the Distributor I have SQL Server 2000 Standard Edition, no service packs applied. This is runningas a named instance, with the default i...more >>

I ve a problem regarding SQL SERVER 2000. I am running SQL SERVER on Windows 2000. The problem is that ONLY SQL SERVER Agent is not running. It is first started successfully then it is stopped. Due to this I am unable to replicate data, which is v.v. import. The simple solution for the prob...more >>

I'm new to replication but would like to start by backing up data from a cluster (2 SQL Server 2000 machines) to a non-cluster SQL Server machine. This machine will hopefully be as close to real time as possible, but should not be in the cluster. Are there any issues I should be aware regardin...more >>

Hi All, I have a Symbol PPT 2837 with PPC 2002 and SQL CE 2.0 trying to merge with a SQL Server 2000 DB over a GPRS Connection. I can establish a connection between the PPT 2837 and the Server over GPRS. The problem arises when I try to replicate. In 'some cases' the sync will download from...more >>

I'm trying to set up replication between two database servers with 1 table only. The table is filtered vertically whereby only 10 out of the 15 columns are used. When I test it out I keep receiving the following error when the snapshot is trying to be applied: String data, right trunc...more >>

how can I check what kind of replication setup we have. i.e. transactional, snapshot etc. TIA ...more >>

Hi I am having a problem that I was hoping someone may be able to help me with. I have a webserver running windows 2003 web edition with msde and a windows 2000 server running sql 2000. I have managed to setup enterprise manager to administer the databases on the web server. However I can...more >>

I have merge replication setup with a push subscritpion continuosly updating. It seems to be working. But I have the SQL Server Enterprise Manager open and am on the publisher, replication monitor, publishers, apollo, publication, and I am looking at the push agent. I am getting a lot (abo...more >>

I am looking to use my main server to keep my laptop updated. Both machines are running SQL2000 , Main server is win 2003 and laptop is xp pro. Im am fairly new to this side of things and am looking for assistance or a tutorial to set this up. can anyone help ? ...more >>

Hi there, We have to aply changes to a replicated database. Basically a tablefield has to change from varchar(60) to varchar(80). These changes are aplied to the subscriber, but to aply them to the publishing db its looks like we have to drop the subscriptors, then aply the changes and add the ...more >>

I am a novice trying to install MS CRM for the first time and got this error when trying to add Domain Users to the Replication Monitor/Publisher/SQL Server/Publication Access List. When I try to click on the MSCRM Publication Properties, I get the following error message: SQL Server rep...more >>

We want to have a Transaction replication topology with Immediate updating option. We want to have both publishers and subscribers do the updates. I created the Publication using the wizard. In the dialog box 'Publication Properties', under the tab 'Updatable', 'Allow Immediate Subscriptions'...more >>

I'm trying to setup a server as a distributor using the "Configure Publishing and Distribution Wisard" but get the following error: Error 18483: Could not connect to server 'xxxxxx' because 'distributor_admin' is not defined as a remote login at the server. Any ideas what to do? Thanks, ...more >>

Hello! I have set up a merge replication scenario with one SQL Server 2000 sp3 as a publisher and distributor, and one PocketPc 2002 pull subscriber running SQL Server CE. This is working quite well except for one thing, whenever i want to synchronize data with the distributor i always ge...more >>

I need to setup continuous merge replication from the main server in FL to a remote server in IN. The FL server is both the publisher and distributor. Should i PUSH the subscribtions to IN or should IN PULL the subscriptions? ALso, later I will have to setup another company that has 3 differen...more >>

I have set transaction replication with multiple publisher-single subscriber At some of the publishers ,the distributor agent and log agent displayis as 'No Replicated Transactions are Available' - thereby meaning that the replication has been properly synchronised and that all the data that was ...more >>

Hi, Is it possible to setup transactional replication, where the data in columns on certain tables is updated at the subscriber on a semi-frequent basis? Will I receive conflict errors? Thanks, Russ ...more >>

Hello: I am trying to get a game plan for establishing Replication between two remote Agencies using VPN. Each has their own local SQL Server Networks. I installed the same database having about 100 tables at both locations. Since then each agency has added records to their copy of the original ...more >>

Having fully investigated MS Access replication and have come to the conclusion that it is unreliable and will soon be unsupported, i.e. deprecated JRO objects ( ActiveX object for replication)and no Replication Manager in Visual Studio for Office Systems, I have decided to look at SQL Server re...more >>

I hope I get a good number of responses to this, as it is quite important. I need to make a final recommendation to a client concerning the use of replication. I have spent the last two weeks browsing the 'Net and getting advice from a number of people. A special thanks to Hilary Cotte...more >>

I hope I get a good number of responses to this, as it is quite important. I need to make a final recommendation to a client concerning the use of replication. I have spent the last two weeks browsing the 'Net and getting advice from a number of people. A special thanks to Hilary Cotte...more >>

hi thank you for your help, but I still encounter the same error. I have ensured the share of the file (.mdb) and folder has the user "Everyone", "Network" with full control on the network computer. For the SQLAgent service at the publisher computer, I have tried using "local syste...more >>

To bring a replacement server online, I created a backup off the old server and restored it onto the new server (after business hours, so no data changes took place during this process). There are 3 merge replications that had the old server as a subscriber, but after the DB restore I rep...more >>

I have a database that is being replicated using Merge replication. the subscribers are four remote locations and a single publisher. I have found an error with one of the field lengths in a table. I want to change the publisher database but am not sure if the change will be pushed to the sub...more >>

I'm using Sql Server 2000. I read about one of the limitations of transactional replication of text field is we cannot update it in the subscriber. Howerver, I just did a quick test of updating (see below) and the field got updated normally. Did I miss anything? Thanks! --I ran this in t...more >>

I have a database that is involved in Merge Replication (Sql2000) After recovering this database onto a new server (we are rolling out a new replacement server) I see and access the database nicely (sql2000 sp3a). However, I cannot drop/delete this database (on the new server) as I get ...more >>

I am intersted in finding out how to change the seed values of subscribers.... We are running into an issue where the initial seed value ranges that were setup are going to run out fairly soon. How ca nI go about changing the ranges for the subcribers without screwing up the existing data Thanks...more >>

I have an existing database that I am setting up for Merge replication. I have modified all IDENTITY columns to be NFR, and added a rowguid default(newid()) to EVERY table. I setup the publisher, all is fine. I then setup the publication and I get an error: CREATE UNIQUE INDEX terminated becau...more >>

Hi all , 1- All the best for 2004 2- I have field type int and i want to join it to data that resides in another database on the same server How can i do this?...more >>

HI, I TESTED THE THEORY OF LOCKING BY HILLARY COTTER. I AM ABLE TO ADD ARTICLES FOR STORED PROCS AND OTHER OBJECTS. ITS ONLY FOR TABLES. THAT THE 'ADD ARTICLE ' SCRIPT HANGS. EM AND QA BOTH HANG AND THE RESULT IS FELT ON USERS WHO ARE LOCKED.......more >>

Hello All Is it possible to have a standby distributor in case the working one fails. I guess all the subscriptions and publications would have to be reconfigured. Has anybody done this ? Thanks A Spencer ...more >>