If I change the table structure of an article in a merge publication, is it necessary to rerun the snapshot agent manually? ...more >>

I need to replicate data between two servers through modem. The problem is that the modem always disconnect in the middle of the process. This is not the initial replication. There were some success until the last days, and there are data changes in both publisher and subscriber that need to be...more >>

How many subscribers can Transactional replcation with queue update support ? ...more >>

Hi I am using merge replication to sync sqlserver 2000 sp3 database and sql server ce 2.0 sp3 via PPC 2003. I received the following error. "Sql CE Exception: Create subscription failed: system.Data.Sqlserverce.sqlceException" "Create subscription failed (27750 - 8004005)" Please hel...more >>

When I try to create and manage publication in SQL 7.0, I got the following error message: Error 21085: The retention period must be less than the retention period for the distribution database. I try to create publishor and distributor on the same server. Thank you....more >>

hi, I need to set a new SEED value to an existing identity column through Query. I used the following DBCC CHECKIDENT (jobs, RESEED, 30) but Enterprise Manager still shows the old SEED value. Can u help me? Thanks Soura ...more >>

Hi, I have a snapshot replication between two SQL server 2000 (Main Svr & Backup Svr). At present the replication is working well but now due enhancement i need to alter soem of the table. When I perform the alteration to the 'Main Svr' I get a error message 'Cannot delete and create table an...more >>

I'm learning replication and am wanting to check if my understanding is correct: If snapshot replication is set up with 'delete all data' for article name conflicts and the replication fails midway eg from connection failure (after existing data is deleted and before new data is inserted), ...more >>

Quick question. Merge replication with pull subscriptions. What happens if the synchornization is interrupted? Does it rollback what's happened? Can a synchronization follow that picks up where it left off? Or, does it require a reinitalization? I can't find anything in BoL or Google th...more >>

Hi, Here is the msg i received while i synchronize a subscriber Category:NULL Source: Merge Replication Provider Number: -2147201001 Message: The schema script 'exec dbo.sp_MSsetlastsentgen '1C901AAC-D531-4E18-BE39-2534877A8975','114397','F0ED62EE-185C-424C-8695-D3A957EC445C'' could not b...more >>

I am trying to replicate over a dial-up connection a database between a server running Sql Server 2000 on Windows 2000 server and two SQL server 2000 personal edition on Windows XP pro. For one site, the replication worked correclty. For the other one, the replication process starts, but when ...more >>

Hi, 1 ) is there a way to drop the conlict table ? (named ?onflit_Pubname_ArticleName) where ? can a;b;c etc.... Why aren't they erased when the conflict is solved ? 2) Why do i have to execute this delete from MSmerge_genhistory where generation not in (select generation from msm...more >>

I am testing transactional replication between two servers using immediate updating. I have successfully replicated numerous databases. I can see the changes reflected on the subscriber within seconds. Part of my fallback and recovery plans, in the event the current publisher has a hardware fa...more >>

I'm assessing the capabilities of merge replication between SQL SVR 2000 and pocket pc devices. I'm building an app for a software company that wants to put their desktop app on the pocket pc. These customers will already have the desktop app installed and running. I'd like to be able to filte...more >>

Using the following call from a .Net 2003 windows app worked fine prior to applying service pack 3a. After this it returns an error. It still works OK if called from query analyser. Connection string used: Data Source=127.0.0.1;TRUSTED_CONNECTION=yes;Persist Security Info=False;Initial C...more >>

Hello. I need to setup a filter for a really busy db that we are replicating. I was wondering what type of filter to use. I am afraid that the where clause of a row filter will create a major performance hit. I was looking into dts and Transformable Subscriptions but am not real clea...more >>

Hi all, I have a problem by using GPRS in a merge replication. I have an SQL Servers with 4 publications, these publication have horizontal filtering, and they have about 20 Articles each of them. I need the horizontal filtering because the client databases (client laptops use MSDE) onl...more >>

SQL 2k & Win 2k I have a server(S1) that has a trans. publication of 4 tables. I have another server (S2) that has a subscription to the publication on S1. This works fine. Now, S2 has a merge publication of the same 4 tables to several remote locations. I have a filter in the publi...more >>

I am trying to replicate a database but it seems to go into endless loop showing: Processing article: 'Table1' Processing article: 'Table2' Processing article: 'Table3' Processing article: 'Table1' Processing article: 'Table2' .. .. .. I stopped it after quite a lot of loop cycles, but i...more >>

What issues arrise when using 64 bit SQL2000 as a publisher , and a 32 bit SQL2000 server distributing to other 32 bit SQL2000 subscribers? I hope to not have to invest in 64 bit technology for our reporting servers. Thanks, --- Posted using Wimdows.net NntpNews Component - Post Made from ...more >>

Hi to all i have two sql servers the first one is a win 2000 sever serverA and the second one is a win xp ServerB ..i have created a push subscription at sql server ServerA ..i had many problems finally i installed the sp3 on both machine ..the first time i ran the replication at serverA via a...more >>

Hello, My situation is as follows: I use Replication in my Mobile Application and when the PocketPc is connected via USB the replication works fine. But when I tried to synchonize the data via WLAN it does not work. My quoted url in my code looks as follows: oRpl.InternetUrl = "http://...more >>

I try to configure replication between 2 SQL Server 2000 servers with another SQL Server 2000 machine configured as the distributor. (All with SP3) I initialize the replication with 'subscribers already has the data schema en the data' and I use pull subscription. When I have finished the ...more >>

Hi, I want to make two database one a same server, database A will have a table named "T" and I would like to make database B have a table which will contain the data of table on Database A. just like a link to table "T" of database A. Can I do it by replication? and how to set up i...more >>

Reading this pretty incredible book on SQL2000 Transactional and Snapshot replication and wondering when Volume 2 is coming out? ...more >>

Hi All, I'm running in circles here... I'm new in replication, my first step is to configure publishing but is asking me for a service start account. I'm using sa with secure pwd to login into the sql server if I leave the system account I got a error message saying that this account with mad...more >>

I get this message when I try to insert a row into a Published table in the publisher/distributor, If I try to insert the table in te subscriber, it works ok. I have the same settings inother four replications and it works fine. Using SQL Server Enterprise in the Publisher/Distributor and Sq...more >>

I am trying to make a replication between two PCs, From Local Server to Remote Server... I have an SQL Server Installed on my network PC ( Its IP : 192.168.1.200 ), and I have another SQL Server Account on Remote site ( on dedicated server at somewhere, It s IP for example : 88.22.33.44 ) an...more >>

Maybe someone can give me a hint on this. -- Right-clicking on the distribution agent offers an option, "run agent on subscriber". I want to try that. Box comes up that says "Subscriber must be prepared ..." and with a button that says it will verify subscriber. I click that and get an ...more >>

It’s about the transactional replication and the publisher’s transaction log. The database that is being replicated is in ‘simple’ recovery model. The problem is that once in a while the transaction log grows 3, 4 times bigger than its normal size. Over the time it stabilized it self t...more >>

Hi. I have a publication databse that become suspect. It is a test database, and I don't have backup. I'm trying drop this, but I can't, SQL Server return a error message: Cannot drop the database 'teste_replica' because it is being used for replication. I tried reset suspect status with sp_r...more >>

Hi all, I was hoping someone can assist me in a problem that has been going on for some time. We have been experiencing replication problems for a while, when replicating data (1 table of approx 150,000 records, 1 of 75,000) to our SQL server on our website. We have noticed a lot of gene...more >>

Hi, I have configured merge replication with pull subscriptions. One of the articles have an identity column as a primary key. At the begining i have problems with the use of the identity column so, i defined an identity range on the article properties. The range i defined was 500000 for each ...more >>

I am using GFI LanGuard SELM 5.0 to monitor events on a critical server. I need a command / file to run when the event 12293 is generated. The program will monitor for the event to be generated...i am just looking for a script that will start replication on the subscription COMMERCE30:Co...more >>

Isn't there a wizardly way to set the polling interval for transactional replication? Only way I can find to do it is to right-click up the distribution agent, edit the command line, stop and start it all manually. (This is correct, isn't it, that when you set the polling interval for transa...more >>

"Non-SysAdmins have been denied permission to run replication jobsteps without a proxy account. The step failed." What sould I do ? ...more >>

Hi, I want to take my replicated db SQL 7 and put a data only version of it on to a dev box. I remember doing this with no problems in the past, but I did it yesterday and it took forever with lots of fiddling about. The restore in EM never actually completed. I am now trying to run my ...more >>

Consider the following scenario: Using merge replication - ServerA is publisher of a database, ServerB is a subscriber, of a subscription pushed to it from ServerA. ServerA's harddisk crashes, never to be heard from again. We change ODBC connections to ServerB and are thrilled for replica...more >>

says general network error, but i have a terminal ping going to this machine with no drops at all. It's weird. about 12million rows, and when it gets done it just starts back over. any ideas -comb...more >>

Doing transactional replication, set up with nosync initialization, it seems to work great, but does not generate and does not use custom SPs for each input/update/delete. In the profiler I can see that, after I run a simple "update" statement on the publisher, the same SQL gets run on the sub...more >>

Hi - Suppose I wanted to do replication (merge) between two machines that are not part of a domain. So I create the same Windows account on both machines (with the same password) and start SQL Server services under those accounts. Can I do all replication operations in this scenario? ...more >>

Hello there I have server who is declered as publisher and distributore already, and i have already active publisher Now i'm trying to create new publish for another database. I get error 14294: Supply either @job_id or @job_name ti identify job Where can be the problem? ...more >>

Ive rebuild the Indexes on a Replicated db weekly. However, it makes the Log Reader Agent blow up with "cannot exec sp_replcmds" error. It doesnt restart until done manually. Any ideas on how to fix? -- SQL2K SP3 TIA, ChrisR ...more >>

Hi, I have problems with merge replication over modem connection. It works fine over LAN but with modem connection I got error: "The merge process encountered an unexpected network error.". I have tried to modified timeout, query timeout etc. - nothing helps. Problems started for few days ago...more >>