I have two Windows XP SP2 machines with full installs of SQL Server 2005. Both machines are on a Class III private network with four computers on it, and no server. Machine A has a database that we'd like to end up, in full, on Machine B, once per day at 12:05AM. Seems like Machine A should...more >>

We created a script to create new tables for all tables that have an Identity column. The new tables now have Identity (Not For Replication). We then copied all the data to the new tables, dropped the old tables and renamed the new temporary tables back to the original table name. We then...more >>

In my replication, I noticed the following error. Can you guide me to the right direction to troubleshoot this. In the Last command section: {CALL sp_MSins_GCFD$Sales Header (0x0000000001b52c48, 1, 'ORD211801', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 2006-08-31 ...more >>

I have installed transactional replication with queued updating on a sql server 2000 (SP4) system. It has run fine until the other when the network went down. When it came back up, replication came back up successfully except for the queue reader agent. I researched the problem and it was due ...more >>

Publisher: SQL2000 Ent Ed sp4 Distributor: SQL2000 Ent Ed active/passive cluster sp4 Subscriber: SQL2000 Std Ed sp4 I dropped an existing subscription in a 30 table merge pub (5 tables w/ 1Mill+ rows), performed table maintenance at subscriber, then added subscription w/ @sync_type = 'non...more >>

Hi all, I have a issue with merge replication. I have setup replication between 2005 and 2000 SQL Server. But, i cannot initiate replication bcaz "JOB HISTORY" says the following: step ID 1 Server Store_Server Job Name Centre_Server_CentreDB_CentrePublicat...more >>

Hi, I have a SQL2005SP1 publushed database with 4 merge subscribers, everything has been running just fine for month now. Yesterday two of the subscribers stopped merging. This happened when I installed Reporting Services on the publisher. From Management Studio, if I right click on one ...more >>

I have 13 push subscriptions all using SQL Server 2000. The publisher/distributor are together on another server are also on SQL Server 2000. Subscriptions have been running for years without problems. Yesterday, 2 of the subscriptions started erroring. The error message is the same on both...more >>

Does anybody know of an example script to quiesce a peer-to-peer replication, alter a view, make sure the alterations are propagated and re-activate the replication? I gather I have to execute sp_requestpeerresponse and sp_helppeerresponse, then alter the table. Trying to build up to the corr...more >>

Hi, After some very helpful advice from this forum, I have set up Merge replication on 2 SQL Server and 1 SQL Express machines. One of the SQL Servers has been configured as the publisher and the other one and the SQL Express as subscribers. This grouping of machines will be repeated th...more >>

Hi everyone, Hope that you an help me with this one - I'm new to the whole replciation business. I'm going to implement bi-directional transactional replication on 2 servers that I have - I'll call them "A" and "B" for the sake of simplicity. The protocol that I am following is the one at t...more >>

I have merge replication running with the following topology: SQL2K5(PUB)------->SQL2K5(REPUB/SUB)------->SQLExpress2K5(SUB) So, I have a publication which is pulled by two republishers/subscribers. My clients pull from one of the two republishers. The articles are filtered by HOSTNAME()...more >>

sp_publication_validation does not seem to show any errors/mismatches after I delete a bunch of rows from a subscribed table. The ManStud GUI validation function works fine and catches the mismatch in row counts. use opeidev go declare @ReturnCode int exec @ReturnCode = sp_publication_va...more >>

Hello everyone, We have SQL 2000 servers connected by transactional replication. We are using custom SPs to push data accross. Suddenly this morning, replication started acting strange, to be more descriptive - one of the articles has 8 columns and is defined to use MCALL type SP for upda...more >>

Hi, My main question is whether the operation is atomic or not. For snapshot replication in sql server, how does the subscription server apply the table change - is it a drop/create, or a truncate/bcp? And is it wrapped in a transaction. Replication is happening roughly every minute (for a ...more >>

Is there any licensing requirement for either push/pull merge replication from SQL 2005 Standard Edition (Publisher) to SQL 2005 Express (Subscriber), we have a per processor license. Thanks in advance Robbie...more >>

Is there any way of preventing this stored procedure from truncating the final scripts it produces (for sp_MSins_*, sp_MSUpd_* and sp_MSDel_*) if a large number of columns are used in the replication model? Thanks -- Peter Doyle...more >>

Kan anyone help me with this one? I have Merge replication set on a SQL server 2005 for about 20 salesmen using SQL Mobile. It used to be OK before, but now it has become very slow. I can see in the monitor that there are about 170000 inserts and 110000 deletions when I test on an initial syn...more >>

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