Hi! I have problem with Merge Replication between two SqlServers connected via internet. After i configured publication and subscriber, when i trying to synhronize i'm obtaining The process could not access to the Subscriber" thanks in advance -- pozdrawiam Jakub Gluszkiewicz ...more >>

We are working on an application that is running data on a local sql server 2000 database. There is a second sql server on a different domain, connected via vpn. Database on main domain sql server is replicated / merge / push published to the 2nd domain sql server The goal is to be availab...more >>

I met the following error Failed to enumerate changes in the filtered articles. Category: NULL Source: Merge Replication Provider Number: -2147200925 Message: Failed to enumerate changes in the filtered articles. Category: COMMAND Source: Failed Command Number: 0 Message: create ...more >>

I need transactional replication to replicate data between a database with a collation of SQL_Latin1_General_CP1_CI_AS and another with Latin1_General_BIN. Can this be done with any explicit conversion? Reading the BOL and searching the internet yeilded no definitive answer. ...more >>

I have to determine the best (affordable) physical architecture for the following scenario. We will have an eCommerce solution that has 200+ SQLServer databases running on Windows 2000 server (normal server, not the Advanced or Datacentre editions) and I need to determine the best solution for...more >>

Hi I've got a problem with the following setup: I configured a SQL Server 2000 for Merge Replication same server acts a distributor set up a publication (whole database) and now I want a client with a MSDE 2000 version running, to PULL -replicate the initial snapshot is created the connec...more >>

Hello Is it possible that the Publisher could wait some time ( about 15 seconds) before it starts publishing ? I want it to start publishing when it gets new data, but there can be about 1000 new records in few seconds and I think it would be better to wait for few seconds then to create new p...more >>

I need to add some fields to an existing publisher to replicate to the other offices. The problem is that all offices have been populating these fields locally for about two months. I was told that when I add the fields to the publisher that it will overwrite those fields in the other database...more >>

Hi Freinds, How can I handle FK relation between Paretn and chile tables? I am receiving errors, indicating that parent record doesn't exist. I am sure it does in the table but my guess is that it is replicating the child table first. What is the soloution ? Thanks, Patrick ...more >>

Running SQL 2K & Win 2K I have 18 remote servers that I want to horizontally filter data to based on the location of the server. The names of the servers are STORE01SERVER to STORE18SERVER. I know I can create a publication for each of the remote servers and then subscribe to the publica...more >>

HI there, just wanted to know if there is a way to replicate my database without adding the MSrepl_tran_version column to my tables? This column is creating a stuff up in my asp code. I am not sure what is NOT FOR REPLICATION option and where can I enable/disable it? thanks,...more >>

SQL 2000 /Windows 2000 Server I need to shut the publisher down and remove it from the network. Then I need the subscriber to now become the publisher and push to other subscribers. Is this as easy as just removing Data Replication, and then recreating it, making the old subscriber, the ...more >>

Hi, How can I start a merge agent from within a stored procedure? Any help would be greatly appreciated. Amin ...more >>

I have used Access replication for years and now I need to setup for SQL 2000 and I need some help. Can SQL 2000 do partials? Where can I read up on using MSDE on laptops to synch? Thanks. David ...more >>

I've got a big and urgent problem... I need to alter some tables in a database. I had those tables replicated. I removed the replication to make thoses changes. All the objects created by the replication are still there, and the fields added in the tables also. When I want to change a...more >>

This is for transactional replication. I have a publisher (sqlA) using a distributors (replA) that is pushing to subscriber (subA). (sqlA) ---> (replA) ---> (subA) I want to keep the publisher and subscriber the same and want to switch the distributor without reinitialization. So the...more >>

Running Win 2k & SQL 2k How do I create or modify an already created publication to only replacate Inserts?...more >>

Hi There, I added a new column on our publishe table which went okay but when i synchronize it display this error message, please help me how can i solve this problem. All our user need to synchronize the data every day. Erro during merge controlInitializephase: The subscripitn to publ...more >>

Hi Guys I have a client with the following below question: Our replication has been working like a bomb but every now & again we get that "Generic Network error" & inserts could not get enumerated or a meta tag could not be generated errors. Replication starts up again but we have no...more >>

When I am in my publications folder and I attempt to add a new publication, I get.... 'Error 5: [SQL-DMO]Code Execution exception: EXCEPTION_ACCESS_VIOLATION' after I click next for the first time. If I click OK in the error box, there are no publication databases listed. HELP!!!! ...more >>

Here's my problem I have setup a transactional replication with a push subscription, I schedule it to run every hour, every think works good, however when the schedule start synchronizing it never stops so its not stating at the next hour, I have to manually click stop synchronizing and the...more >>

Dear Friends I am getting the following problem while adding a column in the replication table. Please suggest. Problem: Code: sp_repladdcolumn [ @source_object = ] 'OTHALLOCATION' , [ @column = ] 'CCICAPPNUM' ] [ , [ @typetext = ] 'NVARCHAR(50)' ] [ , [ @publicat...more >>

Hi All, I have a replicated (published) database with 1 push subscription to it on another server. Replication type is Transactional with "pushing" occuring every 2 hours. 1) In BOL it is mentioned, for making a change (besides adding or dropping a column) in a published table - a) de...more >>

Hi I have setup a merge replication database with a publisher and a subscriber. Now I wish to add a second subscriber that is a read only subscriber. I have read in the msdn as well as the sql server 2000 administration book that checking the show advanced options checkbox on the first wizard p...more >>

Hi, In my db I have a big table with at least 40 millions rows. In fact my appz soffer about performance and I had to put offline the oldest data. I keep online only the last 6 monthsm and I copy the oldest in some tables with data costraints... I mean I have a table called "TbPrices" and ...more >>

Hi ... having a problem with an application that relies on merge replication among three SQL Servers. Two of the servers are public, the other's behind a firewall. Periodically the CPUs on the public servers spikes, and sqlserver.exe is consuming the whole thing. Running "select * from maste...more >>

Hi I configured a transactional replication. It's OK, but some comands in publisher broke some roles in subscriber (I defined primary keys and constraints in subscriber database). The distribuition agent stoped, and now I need to drop these command from the publisher or distribution database....more >>

We have about 90 sites doing merge replication with pull subscriptions over a DSL VPN. Replication often stalls following a dropped connection. Normally, restarting SQL Server Agent at the subsciber gets things moving again. Any good suggestions on a way to a perform this restart. We can't r...more >>

Dear Friends I have setup a merge replicaion between my two servers and now i want to add some column in one table kindly suggest how i can do the same without stoping the replicaiton. your earlier reply will guide me to solve the problem. Best regards Sharad...more >>

When I am in my publications folder and I attempt to add a new publication, I get.... 'Error 5: [SQL-DMO]Code Execution exception: EXCEPTION_ACCESS_VIOLATION' after I click next for the first time. If I click OK in the error box, there are no publication databases listed. HELP!!!! ...more >>

Are there any issues with sql2000 replication on server 2003? We are adding a new distributor and it's OS is server2003ent. Thanks, ...more >>

Hi group, sorry if i post my question again but because vacation i still have the problem and can`t answer the question of Hilary. we are using W2K and SQL Server 2K with SP2. We have a merge Replication (no mix, only 2 Merge Replikation) I have the following problem with the Conflict Manage...more >>

Help! When we try to to delete a test publication on our sql server 2000 Developer Edition SP3a it returns an Error 2812: "Could not find stored procedure" What's weird is that we configured "Publishing, Subscribers and Distribution" last night and after some tries we got thru the wixard an...more >>

Hi. I need to add a new foreign key to a merge replicated table (It references the PK in the same table). Is there anyway of replicating this to the other subscribers without invalidating the snapshot or applying it separately on each server? ...more >>

I'm testing merge replication between a SQL server 2000 publisher and multiple MSDE subscribers. The publication consists of somewhere around 200 articles (tables, views, store procs). All subscriptions are pull subscriptions. My test environment has roughly 10 subscribers. So far the...more >>

Running SQL 2K & Win 2K I have a trans pub from Server A(lets call it PUB 1a) & Server B(lets call it PUB 1b) & Server C(lets call it PUB 1c) to Server X. ALL data from Servers A, B & C are replicated to Server X. Now I want to replicate with a filter some of the data that is on: Ser...more >>

Hi, I have been told a conversion table exist in either the master or the msdb database which can do a character conversion of data before it is sent to a subscriber. I am not not talking about character set conversion but about the ability to modify named characters into another named charact...more >>

hello every one i am using Microsoft SQL Server 2000 Enterprise Edition and running four data bases on server.All on Local Areal Network the size of every data bases is 1 GB and changing occour every Second and minute so i want to implement Differential Backup after every O...more >>

Hello, I want to setup a replication like below on two Windows 2000 Server, Server A: Distributor & Publisher (SQL 2000) Server B: Pull Subscriber (SQL 2000) However, I receive the below error just after I setup the Publisher on server A, any idea of that? All helps are appreciated! Both ...more >>

Hello everybory Some general question about Transactionnal Replication features on SQL 2000 In case of using Trans. Repl. to duplicate a whole database to another SQL 2000 server, does the Transactionnal Replication preserve database's filegroup (i.e. tables/indexes distributed accross dif...more >>

Hilary, please can you send me an alternative email address - I seem to be marked as a dodgy spammer on your current one: "<smtp-out1.blueyonder.co.uk #5.5.0 smtp;550-195.188.213.4 blocked by blacklist.mail.ops.worldnet.att.net.>" Thanks, Paul ...more >>

Hello, I would like to setup Merge Replication between a central Sql Server as publisher and a variety of MSDE clients as subscribers. The catch that I am running into is that I want to be able to do this over the Internet. I have set this up with SQL CE, so I assume that it is possible w...more >>

hi all- is there any way to, as the subject so subtly states, force valdation to fail? mind you, i don't want a false positive (failed validation message with no data discrepancies) - i want to somehow prevent records from getting replicated around, if possible. i'm trying to test ways of so...more >>

I have a SQL Server 2000 with SP3A on Windows 2000 Server. I have a 120 GB database that I would like to create a set up SQL Server 2000 transactional replication. I would like to replicate 60% of the tables. Update transaction at 20 MB/sec. Please help me define the database transac...more >>

Hi I have a very strange thing here. I have setup a indexed view on a table and in this view spilits one CHAR(10) column to 2 (one with first 2 char, and another with next 8 char and converts to int) then I created article and subscription on this indexed view. no problem at this time. The...more >>

Hello, Have a question regarding Log Shipping - if this is not the right group please let me know which one would be. I have log shipping setup but am having problems that I am trying to debug. 1. In the log_shipping_plan_databases table in msdb of destination server the last_file_copied ...more >>

Hi I have a server with Windows 2000 Server SP4 and SQL 2000 with SP3. This server has several published databases that they replicate data to another server. All the replications is of transactional type. When creating to publish another database it leaves me the following error: E...more >>

Hello, When I create merge replication publication with dbo as owner of all tables, I can apply dynamic filters properly. However when my DB owner is TechnicalAdmin SQL Server Login and all the table owner is also TechnicalAdmin, I get the following error when I try applying dynamic filter an...more >>

hi I need to do synchronization manually from outside of sql server enterprise manager . for example with a stored procedure is there any way to do so? ...more >>

Tring to subscribe a merge publication but receiving error at the distributer: "The agent is suspect. No response within last 10 minuts". At the subscriber the error is: "The process could not deliver the snapshot to the Subscriber. The step failed". When viewing the session details at the dist...more >>