Hello How can i delete the conflict tables rows? any SP command is there? Sam...more >>

Hello, I have set up queued updating Transactional Repl. The Queue Reader keeps failing and cannot start up any more. The output shows the following error "cannot have more than one instance of queue reader agent for the distribution database". What does this error message mean? Please help...more >>

I realize this may not be fully supported, but is there a SQL trick that can be used at the publisher to force all the rows in a particular article to be downloaded to the subscribers? This is where a merge publication is being used and the subscribers are anonymous. I continue to be plagu...more >>

Hello. I am needing to basically duplicate a db sitting on a clustered instance of a sql server. My goal is to create a close copy of a particular db (basically the most used tables of that db) in order to run reports off of and free up locking from the original db. I was wanting to have ...more >>

I am running transactional replication with a push transformable subscription. I am running into a PK error. After researching the error I have found two transactions tied to record in the subscription database. So I use the following to determine which transaction is getting fired first. ...more >>

I've recently set up a new server using SQL Server 2005, and have migrated all my public databases to it. However, I still have the old server with SQL Server 7 and would like to use it to offload reporting from the 2005 server, and as I've already got transactional replication running with a ...more >>

Hello... We have some tables that had been using Identity columns as a Primary Key...but we abandoned that approach a few weeks ago and adopted GUIDs instead. These tables are included in Publications that were originally on SQL 2000...but we upgraded to SQL 2005. Is there a way I ca...more >>

CREATE TABLE SALES (sale_id INT IDENTITY (1,1), sale_region CHAR(2) ) When replicated, the IDENTITY property is lost. If the Publisher crashed and I wanted to restore the replicated data off the subscriber, I could manually edit the table and turn on the IDENTITY property under Enterprise ...more >>

I need to install a service pack on replicated servers. Server A replicates to Server B and vice versa. From what I understand (but correct me if I'm wrong), I'll need to "Quiesce" the servers and install the service packs simultaneously. But what does that mean. I looked at a KB article,...more >>

Hi is there any way to drop an article in EM which is part of a larger publication which contains other articles, as the article I wish to drop appears with the tick next to it in the publications under articles but it does not allow me to untick this which seems strange. Is this by design ...more >>

Hi: I met a problem this morning. the merge replication agen stopped, the error message shows: The process could not enumerate changes at the 'Publisher'. (Source: Merge Replication Provider (Agent); Error number: -2147200999) --------------------------------------...more >>

Hello, Some hopefully simple questions for the replication experts! SQL Server 2000, transactional replication, one publisher, one subscriber. I have added a column to an article on the publisher and the publisher is already published. Initially I tried to do this as follows: sp_repla...more >>

Hi, We have a setup with merge replication and polling interval of 10 seconds. Frequently merge replication agent stops with deadlocks. On another system we have default polling interval of 60 seconds. this system does not have the above issue. Is it because of low value of polling interval...more >>

Hi, I've restored a merge replicated database (publisher) on a new server without replication. Now i observe that there are some default replication procedures named *_pal in my restored database. What is the way of deleting these replication procedures. What will be the impact of the same. ...more >>

Good Day, After running Merge Snapshot Subscription Job No BCP files are created for the data tables: here is my code for the Merge Articles: --------------------------------------------------- Dim lbResult As Boolean Dim lobjMArt As MergeArticle2 Dim lbHasIdentity As Boolea...more >>

Hello. I have a new issue... I created a publication. It's a Updatable Transaccional Inmediate Updating replication. My C.S.I. is: I have 4 workstation with a localhost web application (subscribers). I have 1 server (Publisher). When I try to enter some data on the subscriber it comes...more >>

Hi, I have a database with SQL Server 2000 and many MSDE. I need to replicate all MSDE database to the central Server, which is SQL Server 2000. Also I dont need to replicate from central database to all other MSDE database. So central database just acts as backup for all MSDE and also the ...more >>

Good Day. I have a server running SQL Server 2000 SP4 as the Distributor and Pulisher. I have multiple XP systems with MSDE SP4 installed as the subscriber. The Databases on the XP systems have a database created during installtion with all of the tables created. I am running into a proble...more >>

Why would the transaction not be replicated using Trans. Repl. with = Immediate Updating Subscriber? What could I have missed? SQLA.Pubs =3D Publisher SQLB.Pubs =3D Subscriber Servers are in same domain (same server actually, just different = instances), when I update publisher the change ...more >>

Hi all, I'm getting a strange error after reinstalling and recovering a database server on a new hardware. It was posted on http://groups.google.com/group/microsoft.public.sqlserver.replication/browse_thread/thread/8533e8e11bc6ab19/c9f6213ef6965f41?lnk=st&q=Error+when+creating+replication%3A+...more >>

We are using SQL 2K with SP4 and is using Transaction replication with the Push method. After adding two tables to a subscription. I started the snapshot agent. It generated the snap shot for that two articles sucessfully. But the two tables are not replicated to the subscriber server. ...more >>

Can someone tell me how to defrag. an MSSQL 7 AND MSSQL 2000 server. We have both ver. 7 and 2000 (running on two different systems). I am not a DBA but I really need to get this done tonight (2/24/2006) while we take our systems down. I will also want to defrag the Windows 2000 and Windows...more >>

Hello! Where can I get the best information about SQL 2005 replication, but please, do not tell me to read books on line, because these new books on line are really step backwards compare to previous version. Paul and Hillary, I 've seen that new book about replication is comming out in ...more >>

Does the PollingInterval parameter on the LogReader and Distribution Agent need to be the same? I've found that if I don't change the default in the job (no parameter) for the LogReader Agent and I include the parameter in the job for the Distribution Agent, the Distribution Agent just hangs ...more >>

Hello, I had a database that was working fine using transactional replication. Now, I am expereincing problems with the distribution agent. I would like to recover the replication using backups from the publisher database. Please verify that the following steps: 1. Get a full backup from pr...more >>

Is it possible to achieve the following...(I'm not an SQL person) Two individual SQL Servers (2000 or 2005), both will need to access the same DB (located on a iSCSI SAN), server one will need to be able to query and create records, while the second server will only allow users to query the ...more >>

Hello I have a production database that i would like to have mirrored on another server. I have never worked with database replication, but from what I understand, changes made to any of the replicated DBs get reflected in all other DBs. What I need is to have the one production database ...more >>

Hello: I am trying to set up transactional replication over the internet where the client (subscriber) has a dyanamic IP address with a firewall and the Publisher (distributor too) has a static IP with a firewall where the port 1433 is directed to the publisher/distrubuter. Under the client net...more >>

I had merge replication fully implemented and working beautifully. However, I recently discovered a 1:many table (tblLoanException) that did not have a foreign_key constraint created on it. So, I took the following actions: 1. I scripted out the creation of the foreign key constraint on ...more >>

hello all, I have implemented a transactional replication (queued updating) that creates a full replica of the main database. The size of the main db is 15GB and the replicated db's size is 12GB. I would like to know why this difference. thank you, peti ...more >>

Hello I have merge Replication MSSQL Server 2000 SP4, One Publisher and 5 subscribers, a) Subscribers1 has inserted the record at 8 AM and Send it to subscribers2 & subscribers3 b) Using DTS, but not insert directly subscribers2 DB its Inserted TempDB to subscribers2 DB usin...more >>

After Removing Merge Replication on SQL2005 (Publisher) I wasn't able to rename Tables, Columns... (Error: ... is used by replication) ... I applied Scripts found here (Thx!) .... no success Digging deeper into the problem I found out that there is a flag in the system view sys.tables call...more >>

I am trying to disable replication via SQL-DMO. I have order Hillary Cotter's book but I can not wait for this answer. What is the SQL-DMO equivlaent of sp_mergesubscription_cleanup. Thanks Brian ...more >>

Hi guys - A client just encountered a problem where he could not insert into a table because of pk constraints. The database is a replica of a merge publication with automatic identity range with settings: Range at Pub : 1000 Range at Sub : 1000 Thresh.: 80 When I ch...more >>

Hi, Recently we changed the hard disk of our production server for a bigger one, so W2K was reinstalled and the database (sql server 2k sp3) was recovered from backup. Database was updated to SP4. Now I'm trying to restore the replication setup we had but I'm having troubles. Our replicatio...more >>

I'm not a db person so please excuse any simplicity or lack of clarity in my question. My company currently uses a model of remote employees updating MS Access dbs and then transferring those dbs to the main office where they are merged with a main Access db. The remote employees are disconne...more >>

Someone knows a way to synchronize data programmatically without using https publication? With sqlexpress i can't use agent job ... thank you, Luca ...more >>

Apparently this parameter will speed up the initial snapshot to a subscriber on sql2000. Has anyone used it ? What kind of improvement did it provide and are there any concerns in using it ? -- Chris...more >>

I have tried both SQL logins with sa permissions and then windows logins also with sa permissions to both servers as well and I still get this message and the Snapshot Agent won't start - any ideas? Replication-Replication Snapshot Subsystem: agent NPRPROD-NPR-NPR-1 failed. Unable to start ...more >>

Hi, I try to set Merg replication. no data that is changed on the subscriber is updated at the publisher. The updated/new data is removed from the subscriber and he return to present the publisher data. I checked scurity issus can find somthing. Thanks in advance. Yohai ...more >>

I'm getting this error on the distribution agent. Am I correct when I say this would be expected in a testing environment where transactions are not being processed by the database regularly? I have now up'd the inactivity threshold to like 720 :-) Also, what’s the best way to recover a...more >>

Hi all, i can't create new subscriptions for my publication since i made a change to a view: i used to have a view called vlAnag i changed the view adding a reference (join) to a new view called vlAnagValidi then added the new view to the articles in my publication since that moment when i ...more >>

Hi, I am currently designing my first SqlSever database and I'm new to replication. For now, I'll be using the database for one single location (Shop). But I'm already planning to use replication in the future for a second shop (a branch actually). I have read a lot with the Books Onl...more >>

Hi all: how can i get rid of the red accross in replication monitor ? i already delete all fail records in merge agent. Cheers Nick ...more >>