I have setup a Merge Replication(Local and Remote Servers) in my application. I am Using a table (for example) Employee in which Empno is a PrimaryKey+Identity field.During Insertion, Iam Getting An Error as "Primary Key Violation".How its possible?.What is the reason behind this?.Please give ...more >>

Hi all, Forgive me if this is a stupid question, but we lost our DBA a few months ago to a better job opportunity. As I am the person on staff who knows most about writing SQL queries, guess who has his duties now? :) (At least I don't have to do backups and such... the person who knows most...more >>

I am replicating data by transactional replication, between 2 float data types, and I am getting different results. '3294676.0' is replicating as '3294676.0000000005'. Does anyone know why this is? My procs and table definitions match, and I shouldn't be expecting to see this. ...more >>

Hi All, When I try it to push a suscriber I got an error: The process could not bulk copy out of table '[dbo].[OrderDetails]'. Function sequence error (Source: ODBC SQL Server Driver (ODBC); Error number: 0) ---------------------------------------------------------------- In the snopshot sai...more >>

Not sure why this keeps happening. The table is not that large compared to others that we do. This is with the 2 set on the logging and still is pretty vague as far as the "general network error".. Any ideas on how to make this snapshot go through. Both our connection and theirs is a ...more >>

Anybody knows where can I find some info related to replicating data from Oracle(Publisher) to SQL Server 2000(Subscriber), some examples? Thanks in advance! ...more >>

We have a replication desing with several publications (merge, unidirectional merge, and snapshot) synchronizing with several MSDE instances on laptops. On one of the uniderectional merges one laptop replicated the first time and received all data (1067 rows). More data was added to the server...more >>

We are trying to implement a warm stand-by sql server, but after initializing a new push subscription, neither the users no the table permissions are being transferred. Isn't the snapshot be responsible for those (sysusers and syspermissions) tables? Thanks...more >>

I have set up the transactional replication with Qued option .. I have a trigger on one of the table which inserts the data in another tables after insert /update activity happens . I have set up the trigger with Not for replication but still the trigger is fired twice without any interva...more >>

Hello All, I would greatly appreciate some help on this issue. I am very stuck and struggling. Basicall I have a SQL 2000 Server, that is the publisher for a merge replication. This merge replication, is to replicate to handhelds, that via a mobile application, insert into the tables. T...more >>

Hi, I'm trying to create a pull subscription but it fails. I would like to synchronize data between my laptop (remote or in network) and our SQL Server. I managed to create a push subscription replicating every hour but it would be better to have a pull subscription. I always get an err...more >>

I have a problem that needs tip: Our main replica server need to be restored. It has been the main server within a network using merge replications between around 10 servers with publications and push/pull subscriptions. Now listen the server was stolen and I need to restore (I got the all the...more >>

Hi, I am trying to create custom merge profile for merge replication between SLQ2000 and MSDE2000. The link between the two is usually 33,6 kb/s. I have checked parameters for 'Slow link profile', but there is only one parameter different comparing to the default profile (UploadGenerationsPer...more >>

In Enterprise Manager (EM), if you go to: [Replication Monitor -> Agents -> Merge Agents] you'll see a list of Merge Agents to the right. I'd like to be able to select one of the items, right-click, and select "Agent Properties". When I do this, I get a dialog box that appears. The title of...more >>

I need to copy 10 Databases (150GB) to another SQL machine. Now I need the destination machine to be updated every 24 hours. Transcational replication is not helping me - cause it doesn't copy tables without primary keys. Snapshot replication is not helping me either - cause i can't transfer e...more >>

Hi, We have a standby server that is located at the remote site connected by a leased line. We have a log shipping that is currently running from our primary server located at hq to the standby server. Everyday there will be a transaction logs and the full database restore been done on the ...more >>

Hi I can't go forward, I have the same error... Paul Ibison was helping but maybe he is busy... please help. Error 18483: could not connect to server 'serverName' because 'distributor_admin' is not defined as a remote login at the server. a) I'm using Named pipes and TCP/IP with not alias becau...more >>

We currently have two machines in a workgroup environment and both are running WIndows XP Pro SP1 and MSDE Sp3. The problem we have is with the Merge Replication. The publisher writes snapshot data to the snapshot folder, but the subscriber is unable to open this file across the network. We...more >>

Hello: I get this number of errors when I'm trying to merge replicate over GPRS. It occurs only some times: error 80072EE7 with native 28562 error 80072EFD with native 28562 and after those errors I get 80004005 with 28557. What about are these errors? why the database gets unstable? h...more >>

We have a setup where SQL Server A servers as a Master database. SQL Server B is installed in another country and replicates key master data from server A. MSDE Instance C replicates with Server B to receive this master data as well as merge data that is shared only between B and C. We recentl...more >>

I am Getting Timeout Problem when the meta data CleanUp Process Related to Merge Replication is running I just want to know a) What event triggers this job to run. b) What does this job does. c) What happens if the job does not run d) whether i can modify the job to run only on Sundays whe...more >>

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