Hi, We are planning to replicate our bussiness database on some of our branches for reducing response times for these sites. Branches will merge it contents at night with our central database, just to avoid the overload of our main server at day. We are planning to deploy around a dozen of sub...more >>

Hi, After deleting the Merge Publication from Replication, Publications, there are still remains of the publication in the database. (the rowguid column in every table and the shared sign on the database icon) We would like to remove them without creating a new database. It looks like runni...more >>

Hi, I have a replicated to table. It has the ID column as unique and I want it to convert it into non unique. How can I do it? ...more >>

I would like to setup log shipping for only a select number of tables within my database. Activity would be happening on a number of tables, but I only want to ship the transactions/logs for specific subset of the tables. Is that possible with MS Log Shipping or another 3rd party tool? ...more >>

Hello ... I am having a problem ,, where my replication is not working .. i.e i cannot see the data in the subscriber database.. i think i am missing something.. the below is my system setup and the steps that i have folllowed.. can u know if i am missing something? Here is my sql syst...more >>

Hi Everyone, I have an application set to merge replicate the MSDE (on remote machies) and SQL (on Server), once the user logs on or logs off the application. What I want is to set the replication so that the database replicates even if the user is not logged on to the application. At the mom...more >>

We have a Publisher and a Distributer in a remote location and a Subcriber in our office. After initial snapshot, we added triggers to some Subscriber's tables, but everytime there is Reinitialization on the Subscriber, we have to recreate triggers. Is there a way to reinitialize and not loos...more >>

How would I set up secure replication between 2 servers that are in different cities? I need just one way (snap shot) push. Would I use SSL or VPN? Help appreciated. Thanks. Steve *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewar...more >>

Hello, I've merge replication set between SQL Server 2000 & SQL CE. Whenever I try to add filter clause to the existing publication, it gives error mentioning the column name used in the filter clause. Ex. Let's say I've 5 publications - Pub1, Pub2, Pub3, Pub4, Pub5. If I add filter clause...more >>

I have perform merge replication in the SQL server with access database, however I would like to change the database schema in the SQL server. How can I do that? e.g. such as adding a field in the table or changing the data type of the column field. Thank you Regards Jabba...more >>

I'm currently exploring ways to perform merge replication between MSDE and SQL Server 2000. Synchonization Manager is of interest but I'd like to clarify a few questions: 1. The Client will be using MSDE to sync with our SQL Server 2000 DB. The MSDE DB will be on a completely different ...more >>

SQL 2000 Currently, I have push transact replication with immediate updates going out to several subscribers. I want to take the publisher off the network and have a subscriber become the publisher... I will remove replication, and then delete the field "msrepl_tran_version" from all...more >>

I am using merge replication over more than 55 users, (anonymous subscribtion). Today I installed MSDE to a new computer (as before in all 55 computer), run the synchronize (1st time), was working fine. when i try to synchronize 2nd time the following message is coming: Error during mer...more >>

I would like to create a merge replication between few db, but I want to keep the replication even if Publisher would be out of order for some time. How can I co that? I'm thinking about creating one of subscribers a new publisher - is it a good idea ? What would You suggest ? What is most re...more >>

Running SQL 2k & Win 2k Two of my four log readers have the following message.... 'replicated transactions are waiting for next log backup' What does this mean?? Is this a problem I should be concerned about?? Are transactions getting replicated?? If this is a problem, how do I fix i...more >>

What would be a best practice for monitoring Replication? I have Transactional Replication going from the Production database = (SQL00) to the Reporting database (SQL03). Are there some Alerts I need to make sure I have setup to notify me? Should I do a Validate Subscription once a week or s...more >>

I need to import any paradox tables in SQL Server 2000, but i'm having troubles with char conversion: Does anyone have any idea about why all accented chars in source paradox table turn into other chars in the new SQL Table: à in paradox turns into Ó in SQL è " " " " Þ ...more >>

The subscriptions has been marked inactive and must be reinitialized. No Sync subscriptions will need to be dropped and recreated. The step failed. Hi all, i am seeing this message in the Distribution job history, Distribution agent failed. please advise me, how to resolve this issue. T...more >>

Have someone tried to measure what is faster? one publication with 2 tables, or two separate publications each with one table ? Best Regards Wojciech Znaniecki ...more >>

My log reader task keeps failing with the error "the process could not execute 'sp_replcmds' on sql01...". I can execute it just fine in QA on the publication server. Is there anything I can do to get around this? Thanks, Andre ...more >>

I have SQL running on SBS Server A. It is a publisher and a distributor of a database that has 1 subscriber a SQL Server running on SBS Server 2. How does one replicate in a untrusted enviroment. there was also a free ware dll that allowed sql to invoke the ras dialer.. does anyone have the ...more >>

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