Hi, I want to replicate data between two SQL Servers but I have connection problem: Server A: Win 2003 SP1, SQL Server 2000 Enterprise Edition SP3 Server B: Win XP SP2, SQL Server 2000 Personal Edition SP3 Server A dials to server B. Server A can ping server B (using IP) and I registered...more >>

SQL 2000: I have a transactional replication with an updatable subscriber. The update method at the subsrciber is set to "queued" (otherwise inserts on the subscriber will fail in case the publisher is off). This has been working fine until yesterday 14:19. Since then inserts on the subscriber...more >>

I am trying to duplicate our production environment in QA. It has a number of fairly large published and subscribed databases on 3 different servers. I am planning to put all of them on one QA server. Would like to be able to do this with nightly refresh of all data from production. Produc...more >>

I want to drop all my pubs and add newly designed pubs in there place. 4G db, sql 2Ksp4. I have 2 main server (1 pub pushing to the other) and 115 anon merge subscribers. I'd love to keep the two servers publications intact and drop all the metatable data for the anon subscribers. In s...more >>

We are using SQL 200 transactional replication. We have a need to update/add various objects (tables, columns, stored procedures, etc.) I was wondering what the best/cleanest way was to do this in order to make sure all the new changes get replicated. I am proposing the following: 1. R...more >>

Hi Guys, I have sql server on SERVER A running on a failover cluster as Distributer and publisher while SERVERB as SUBSCRIBER . I am using TRANSACTIONAL Replication for reporting purposes. which server i have to update sp4 first Pls advice. rgds Biju...more >>

We are setting up a merge replication solution. We have one corporate location and 37 remote server locations. Our current blueprint is to have a corporate publisher with the 37 servers at the remote locations as subscribers over a WAN. Also the 37 servers are publishers with 7 or so subscir...more >>

I'm running replication from SQL Server 2000 to Sybase. Whenever I do a failover from one node to the other I get duplicate rows. That means that certain transactions are done twice. What can I do to avoid that? Thanks, Avi ...more >>

Hi all, I am writing a Insert trigger but to my dismay it is not able to insert explicitly into columns of type Timestamp. Please let me know the work around for this. I am posting the question in this forum because i know Microsoft Replication takes care of this problem well, so if anyon...more >>

I'm running SQL 2005 SP1 and have setup transactional replication to 3 subscribers. The publisher is it's own distributor. I have several tables that are filtered and I keep getting a rows missing error on these tables. I have rebuilt replication several times but I keep ending up with the sam...more >>

SQL2000 sp4 - Transactional Replication - remote distributor, 5 subscribers all SQL2000 Std Ed. I execute the following sp_dropsubscription: exec sp_dropsubscription @publication = 'MyPub' , @article = 'MyTable , @subscriber = 'all' I execute the following sp_droparticle: ...more >>

Can someone please explain what either of these are in 2005 Merge Replication? TIA, ChrisR ...more >>

I am creating a dynamic filtered merge replication using FTP, both machines are SQL 2005(SP1) and are on seperate non-trusted domains within the company.The anonymous user on the FTP site has full rights and no password, this is just a POC. I have set up the publisher to use the unc path the t...more >>

I've found that I'm doing this incorrectly and need some assistance. What would be the proper way to adjust the length of a column's datatype when I have transactional replication setup? I've attempted to drop the column using sp_repldropcolumn and got the message that the column has an ...more >>

Hi All, I am trying to re-create a dynamic snapshot job we once had on our server using the same name, however I am unable to do so. The old dynamic snapshot job has been dropped, but even after running the replication cleanup jobs, I am unable to re-use the name. Upon further investigati...more >>

I'd like to find a program that clearly demonstrates how SQL 2005 failover works (flawlessly). This application would be used to show that a failure can occur and users are not impacted by that failure. This program would: 1) execute a datareader to page through a query displaying its da...more >>

I have two databases in different VAN’s. One in US and the other in India. The requirement is to synchronize these two databases. If I add a record in US database it should reflect in Ind database and vice-versa. I used Transactionla replication, but facing issues with PK's. I th...more >>

Hi, I've just setup an SQL 2005 and trying to setup my database for transactional replication with update subscriber. When the wizard tries to add the tables, an error message for some of my tables appear. The error message is : Arithmetic overflow error converting expression to data type b...more >>

I have sql 2005, and SQL Mobile subscribers (merge replication), everythings been going ok, but the other day, I added a new table to the publication with sp_addmergearticle. That went fine, the table appeared on the handhelds after their next sync.... however the problem came the next day whe...more >>

Hi We upgraded our distribution servers 2 days ago to SQL Server 2005. All our publishers and subscribers are not upgraded yet. After upgrading the distribution servers, some of the logreader and distribution agents are replicating information with no problems, however others distributi...more >>

Hello, I am new in merge replication and i want to monitor that the replication is running. how can i control that in a SQL Server 2000 replication environment? 1) Viewing the state of the agents? if the state of merge agent is "succeeded" can i say that the replication is running? 2) Vi...more >>

My tables have a float PK generated by 'sequence' sproc. Within a single database, this worked fine. Back when, this was an Access app, hence no uniqueid pk. With Merge Repl, I am getting compensating error corrections when the pk is violated. For a few tables, a compensate_for_error...more >>

I need to set up Transactional Replication. I've noticed backup and truncation of Transaction Log is hampered if replication has failed for a database. Whay can anyone suggest to deal with this? Do I? 1) Disable and Unconfigure Replication (Pub & Dist) and run the backup job and then recreate...more >>

From my testing it looks like the Queue Reader Agent pulls every 15 seconds. Is there a way to shorten that interval? Thanks a ton! ...more >>

Hi everyone, I was wondering about what methods I could use to transfer MS Access data (oldTable) to SQL Server2000 (newExistingTable) where in that most columns in the new table are named differently in the old and some columns in the new table don't even exist in the old. As far as I know ...more >>

We write software and have many customers not replicated, but some customers do use replication. During software updates we might change the database by adding columns to a table, altering a column in a table, or adding a new table. I know I can add a column in replication using: exec sp_re...more >>

Recently I started to get the error: The merge process could not retrieve column information for table. Below is trace for the merge agent: [8/23/2006 9:11:53 AM]CHFOH-WS-ENLBL.componentsDb_v4: {call sp_MSgetversion } The merge process could not retrieve column information for table 'dbo.uni...more >>

When I try to apply a replication snapshot at the subscriber I get: ALTER TABLE failed because the following SET options have incorrect settings: 'ANSI_NULLS.'. The step failed. There are no ALTER TABLE statements in the schema for the snapshot, so I'm not sure where this is coming from. ...more >>

In the sql server logs the following error has been reported. Date 22/08/2006 14:24:18 Log SQL Server (Current - 23/08/2006 10:00:00) Source spid85 Message Replication-Replication Merge Subsystem: agent (null) failed. Publication '<publicat...more >>

Hi Im using a snapshot replication, but I need to be able to replicate permisions on the stored procedures. I've created the user on both servers and given the permissions on the publisher, but the permissions are not carried over to the subscriber. What to do ? -- Best regards Mika...more >>

I am trying without success to recreate a publication that I have previously removed. I have tried both to recreate it from script and from the create publication wizard. I can't even create a new publication with a different name. The problem seems to be related to a missing ''dbo.sys...more >>

Hi experts, I was given a requirement to replicate data over a dial-up network. Therefore the key is to keep the amount of replicated data as low as possible. I am aware of Row Filter in a publication. So in order to fullfill the requirement, I will create different publications for each c...more >>

I guess people in this group are the most likely to have solved this kind of issue. Looking for an ftp client that could automatically resume interrupted downloads and send the download result back to the SP. Environment: Win2k3 SQL 2k5 ent Any suggestions? Thanks, Nic ...more >>

We are trying to replicate our SQL Server 2005 database that runs TFS. When we do the replication (which works successfully) TFS can no longer connect. Does anyone know how to fix this? John Wright ...more >>

I used Enterprise Managerto generate table creation scripts for a new DB from a SQL 2K box. I ran this script on a SQL 7 box. The tables were created and is being populated by data. But when tried to replicate this database or any replications created afterwards, it fails due to failure in the...more >>

Hi, I have a Pocket PC application (compact framework 2.0 SP1) on a development evironement that subscribes to publications on an SQL Server 2005 (PPC 2003SE - ASync42 - winXP, winsrv2003 with IIS - winsrv2003 with SQL Server 2005) everything works fine. In our test environement, both, the...more >>