i have transactional replication with a push, updatable subscriber configured and when updates (UPDATEs and DELETEs wrapped in a single transaction) are executed on the subscriber the changes EVENTUALLY make it back to the publisher as they should. the problem i am having is when these sp_...more >>

Is there any way to prevent conflict tables from getting cleared when the snapshot runs?...more >>

We need to push all the changes across network to a secondary, reporting server, on a timely manner. We were using replication in SQL200, but it takes a lot server resources. Any new feathers in SQL2005?...more >>

I am unable to alter or create a publication that uses a particular table. If I try to create a publication with this table or if I try to add or remove a column from my existing publication that uses this table, i get the error message "error 220: arithmetic overflow error for datatype tinyint...more >>

Forgive me for the noob question but I am new to SQL and replication. Need help understanding how to resolve the "Identity Crisis." I have two SQL 2000 servers, one does a simple nightly pull subscription (snapshot) of our DBs to an off-site server - one way rep. Rep is working great but ...more >>

Hi, I'm looking for a solution to the following problem: I'm creating a transactional replication publication on sql 2000. Suppose that @pre_creation_cmd for the article is either drop, truncate or delete (not 'none'). I want that the table created in the subscription database, will either...more >>

So I set up a "Replication/Local Publication" on a Production SQL 2005 Database. It publishes a Database on the production database. I then set up a "Replication/Local Subscription" on another Database we call "Report Database" that will have reports running on it and querying the Subscripti...more >>

Someone (who left the team) has setup my SQL Server 2000 Cluster1\Myinstance It *was* setup to do log-shipping to a DR server and I thought he has setup the instance to be 2+1 LAM Enabled before he left. What tools/techniques can I use to see if the instance is 2+1 LAM enabled and the node...more >>

Hi to all I have a merge replication in SQL 2005 spk1 with 54 Subscribers that are actually Mobile devices. I set the Expiration date to 30 days and now I want to Reduce it lets say to 10 or to 8 days. My Question is this. Will I get faster Synchs if I do that? And By just changi...more >>

Hi, I've a republishing database (using merge replication) which has more than 1 subscriber. The database has gone into suspect mode and there is a problem with 2 tables. I've all the data on its subscribers. However, each subscriber also has some changes which have not been sent to the pub...more >>

Hi All, I have previously posted in the MSDN forums with no responses, so any hints on this would be greatly appreciated. I am replicating an SQL2005 express machine to SQL2005 standard edition server using merge replication. I have a simple VB application using ADO polling msMerge_history ...more >>

I create a merge publication of a database I have on sql server 2005. The target platform for this database is a pocket pc. Everything works great, until I dig under the covers a little. Lets say I have a table a, and that table is filter to only show a subset of its records. When I look at t...more >>

My goal is to setup a DR environment with 3 servers in the pool - 1 Publisher and 2 subscribers (DR servers). The publisher will normally get all the DML hits unless it goes down - in which case one of the subscribers will get all the DML hits. What is my best bet in this scenario to keep d...more >>

Group, I have a publication with 3 articles that get INSERT/UPDATE/DELETE on = publisher and DELETE on subscriber. I need the subscriber deletions = replicated back to publisher so I setup publication that allows = updatable subscribers then I go thru the subscriber wizard to create a = push su...more >>

I have a database that is published. I created a backup, then went to test the restore and I can't, because the database is published. How do I restore?...more >>

I'm working on an application with Compact Framework 2 and SQL Server Mobile 2005. When the application start, if there is no data base in its folder, one is created using CreateDataBase from SqlCeEngine (I'm sure that every object used for that operation is closed after create the file). Afte...more >>

Hi to all, I have a Merge Replication Running on an SQL 2005 spk1 and I want to upgrade it with spk2. Shall I just run spk2 and everything will work fine after that? Thanks. ...more >>

Is it possible to write conflict sql in some persistent table. I know that they a writen in merge replication tables and can be viewed via conflict viewer but they a lost after the snapshot run. I need to keep them forever. Probably i can write custom resolver who will do thta - but is there a...more >>

http://www.nodalsoft.com.cy/ ...more >>

I am testing replication capability of SQL Server 2000. On my personal PC I successfully tested shapshot and merge replications. But on my test server as publisher, distributor, subscriber (Windows Server 2003 standard eddition SP1 and MS SQL server 2000 standard eddition SP4) transactional...more >>

I have transactional replication setup with an updatable subscriber. I want the trigger on the publisher to transfer over to the destination during the initial snapshot (the drop/create is where I lose the trigger). In the GUI, properties of the publisher, Articles tab, clicking the elispse th...more >>

We have run into a situation when merging data into an existing publication for one of our clients. This client had 3 existing locations, each with a subscription to a single publication. (2 databases, 1 publication for each database, 2 subscriptions at each location). We merged the 4th lo...more >>

I am trying to detach my distribution database and it won't let me because it says it is being replicated. I removed replication and all subscriptions and publications. Why is it I still can't get rid of this database? I am running sql 2000....more >>

Hello, I need to relocate the Distribution DB, and I was advised that I need to stop/disable replication to do this. I looked up this article on disabling replication: http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/hasog03.mspx which says (near the bottom of the article) ...more >>

Hi, I'm running a merge publication on a SQL Server 2000 database with several anonymous subscribers. I want to change the subscription expiry from 14 to 28 days. Aside from larger logging tables, are there any important consequences to doing this? In particular, do I need to reinitialise ...more >>

I am attempting to push a SQL 2000 publication to a SQL 2005 server. I realize that Microsoft does not recommend this, but I haven't found anything that says that it can not be done. When I try to register the SQL 2005 server in my Enterprise Manager I get "To connect to this server you m...more >>

I have sqlserver2000 and I have set up replication. Accidentally I have deleted distribution data and distribution database went to suspect state, Is there any way I can recover from this state? ...more >>

i have transactional repl setup with an updatable subscriber. when my initial snapshot is synced to the subscriber, the tables are dropped fine but recreated under a non-dbo user (in my case one that is setup named 'dev'). what controls how the publisher/distributor drops/creates the tables ...more >>

- SQL Server 2005 Std. Ed. (Distributor and Publisher) - SQL Server 2005 Dev Ed. (Subscriber) - Linked servers created on both Publisher and Subscriber As a proof of concept, I've been trying to setup updatable subscription transactional replication between two servers in the same domain. So ...more >>

Greetings, I need to move the Distribution DB to another location because this DB installed on the C drive which is running out of space. But the detach option is grayed out in Enterprise Manager (sql server 2000). Do I need to stop replication before I can move the Distribution DB? wil...more >>

Hi there, Now im not a SQL guy so sorry if this is a stupid question. Im trying to setup Transcational replication between 2 SQL 2000 SP4 servers and im getting the following error on the Distributer+publisher (the same server) "The license for this installation of SQL Server does not p...more >>

We have sql server 2000 ,we r dong transactional replication,out distribution agent latency is around 1000000 from last 2 days before that,it was around 4000,please suggest us the solution immediately. Thank you....more >>

I have a situation where a client connects to our network via VPN has set up a SQL Server on a small workgroup that wishes to subscribe (via transactional replication) to publications on my SQL Publisher. My stumbling block is permissions to the \\myserver\repldata folder on our domain. The...more >>

We noticed a problem while doing Publication on our server: SQL 2005, Windows 2003: 1. Publication works fine, it generates a snapshot every 5 minutes. 2. Change computer system time using Date/Time, say from 3/2/2007 9:20 AM to 3/11/2007 1:40 AM. Observed: Publication stops generating s...more >>

I want to make sure that all the articles in a publication are subscribed to a subscriber. My publication has multiple articles and subscribed to multiple subcribers. I noticed that some some articles were not subcribed to a subscriber. Which query should I use to get all the articles which...more >>

I'm setting up a Merge replication over a very high bandwidth line, and I'm running into many performance problems. 1. I'm publishing the data one-way from the Publisher to one Subscriber at this time. Once the data are synchronized, it's taking forever to push delta data since the snapshot...more >>

Hello, I have a replication error related to the schema script of a procedure that is not longer on the list of articles to replicate from the publisher and also it is not part of the replicated store procedures in the replicas. I someone has an idea what could it be the problem. Please...more >>

I have a database reconciliation script that runs between two databases and reconciles object counts and table counts etc between the two. Is there a way to run such a script across a primary and secondary in log shipping configuration. As the secondary is in RESTORING state it's not accessib...more >>

We have a customer w/ merge replication setup and has been functioning. Their server's were hacked. We have spent 3 days on the phone w/ MS and everything is working except for 1 client. When it is trying to deliver the snapshot it is getting an error: The process could not bulk copy into tabl...more >>

We run a medium-sized web site (40K visitors per day) and our production database is growing fairly large (15GB). While performance is acceptable, we're looking to think ahead and maximize our limited resources. 90% of our traffic is new users; probably another 9% are returning users from the...more >>

Hello there, I'm into merge replication for only two days so Apologies with big A if this is an obvious one. fyi, my context is SQL Server 2005 EE 32bits SP1 running on Windows 2003 EE SP1. I'm trying to simulate a conflict on a merge replication. The MSmerge_conflict_info reports well ...more >>