Hi! Merge replication. From Sql Server 2000 SP4 to MSDE SP4 Using FTP and compressing the initial snapshot. I recently added a user defined function as a computed column on a table. When the anonymous subscriber is sychronizing the initial snapshot, it errors out saying that the use...more >>

I have 2 databases with merge replication set up and a number of tables that have 2 integer fields (one - identity) , a varchar (8000) string field and a rowguid column. When clients are connected to publisher, and the length of the string inserted into a table of above mentioned structure reach...more >>

We are trying to use SQL to replicate a stored procedure for SMS2003 Reporting modifications. Two Questions 1. What Ports are required for SQL replication 2. When we replicate the stored procedure we loose the security settings. How can we replicate and keep these setting. This is for SM...more >>

Hi, I added a new article to an already existing publication via EM, and reintialized it. When the snapshot agent ran the change was replicated, but the snapshot agent took the snapshot of all the articles in the publication about 85 of them, instead of just replicating the change. IS the...more >>

Hi, I am dealing with merge replication. Is there any option(query) to view the lattest conflict records(for current date) for all the conflicted tables? Thanks, Soura. ...more >>

Hi, I have merge replicated, remote server & local server. The database has only one table. It was working fine. More than 15 days, it was isolated without any transaction. After some days (around 15 days) I found that the subscription is dropped. What is the reason for this? Is there ...more >>

Hi, Can I use RDA to sync SQL Server 2000 with another sql server 2000 instance? or is it only available for SQL CE? JJ ...more >>

Hi, we have a database that has a merge publication and a transactional replication too. We need to restore one of its backups in another database, so we did it, and it reported a succesfull. After that when we tryed to execute and update, returns this error: "Server: Msg 208, Level 16, Sta...more >>

Hello... I had a merge publication that I thought was removed....at least it does not appear in Ent. Mgr under the list of Publications. However, in the Replication Monitor the publication still exists. When I click on the publication to delete or check its properties I get the mesage: ...more >>

Man, I am seriously losing faith in this entire Microsoft replication scheme. It seems that every time I turn around, it's another damn weirdo wacko issue -- that cannot be easily resolved. The documentation on how replication works looks like it makes sense, but in the end, it's a $@#* joke...more >>

I have transactional replication set up on SQL Server 2000 SP3a on a Windows 2003 server. The replicated server is also SQL Server 2000 SP3a with Windows 2003. One of the publications contains 6 articles. This publication was configured and pushed to the subscriber all at the same time. On...more >>

The concurrent snapshot for publication<PubName> has not been activated by the Log Reader Agent. What did I do wrong ? I reinitinalized a subscription and the snapshot has completed, but the distrib agent fails to start .. ...more >>

Hi all gurus. We have an app using SQL Server 2000 (PC Side) and SQL Server CE 2.0 (PPC Side); now I'm guessing what effort should be necessary to port the app on PalmOS. We have used 4 PalmOS development CASL, but now we're having a look into AppForge. However, I'd prefer not to move from SQ...more >>

Dear All, I want to set up snapshot replication on server that will serve as Publisher and Distributor for minimum 40 Subcribers. The Subcribers will receive a new snapshot each month. I want to publish 3GB, and it's expected to grow. I Want to minimize workload on the Publisher/Distributor...more >>

...more >>

I want to create an alert each time sql server replication distribution jobs/log agent jobs fails to write to the windows eventlog. Can someone tell me how I can go about doing this?...more >>

Hi, I tried to use 'Minimum Conflict Resolver' for Orders table of Northwind. I entered EmployeeID as 'the information needed by the resolver' and also modified this column for a same row in two different subscribers. I updated one of them to 1 and the other to 5. I expected 1 become the winner...more >>

How can i make my log reader agent fast ? it take so long to complete writing to the distribution database ...more >>

What are the methods by which I can monitor replication/data row changes programmatically? I have looked at the Mergexlib but perhaps I've missed something but that *appears* to be for setting up and then monitoring (which is "ok" except how do I monitor previously configured subscribers? I...more >>

Hi there, The situation is as follows: We have a central server running MS SQL 2000 SP3 on Win2k3 SP1 and bunch of clients running MSDE SP3 (planning to update to SP4) on WinXP/Win2kpro. To synchronize data between server and clients we use merge replication with pull subscription. The ...more >>

From BOL CommitBatchThreshold 1000 The number of replication commands to be issued to the Subscriber before a COMMIT statement is issued. So if the distrib agent report 1 transaction with 100,000 commands are replicated, i guess the above CommitBatchThreshold of 1000 does not apply.. ...more >>

Say if i have 1 transaction and 100000 commands, the entry_time in msrepl_transactions.. is that when all the commands get written for that transaction to ms_replcommands or is it right at the beginning ? ...more >>

.... I monkeyed around with the sysdatabases to detach and then to finally attach.. Is it safe to do so ? ...more >>

Am busily investigating and planning our new SQL replication / backup / DR solution and I've been spending a fair bit of time looking at different replication scenarios. My question to the gurus is this: If cost were no option, and I wanted the most robust, effiicient data replication solu...more >>

Is replication suppose to continually grow the database backups on the distribution machine? I had to remove replication because the backups grew a couple gig in about a months time. Am I missing something? I've tried this twice now with the same results. Thanks....more >>

Hello. I'm new to SQL servers. I'm curious to know if there are any known issues for SQL replication between SQL 7 and SQL 2000. I currently have SQL 7 running on NT 4 SP6a. This server is currently a publisher. I have another server running SQL 2000 on Windows 2000 SP4. It's a clean install...more >>

We have a SQL Server 2000 SP4 running on dual 1.4GHz Intel Pentium III's with 2GB of memory and are replicating out to 30 IBM laptops over a LAN. We have 83 articles in a pull merge replication, with only 6 of those table having 2-way possibilities. Currently we average a delivery rate of 5 ro...more >>

Just need to know, in general, if a subscriber in merge replication (SQL Server 2000) is updating changes to a publisher and the network connection drops, the subscriber hardware fails, etc., what happens? Are any updates that get through rolled back or do they remain? Are any error messages r...more >>

Hi all I'm evaluating a potential replication scenario and I'd like some input from the experts if possible. I've got a 150GB database hosted at my headoffice that I need to replicate to 4 regional offices. The regional offices are connected to the head office by a WAN and I've been told...more >>

i am having 1 header table and 1 child table, there is currently no column to store the number of children relation to 1 header. after replication, the replicated records are to be processed by another program. the problem happen when replication failed half way (due to line drop for instanc...more >>

Hi all: which table keep the subscription sync records information? like sync start time , duration.etc Thanks Nick ...more >>

Is it possible to implement SQL Replication via ftp without expose SQL Server on Internet. I mean if SQL Server is in local mashine and only ftp site is visible to the subscribers. And i dont want to use VPN ...more >>

Is there some easy way to detach a replicated database without dropping the replication around it ? ...more >>

has anyone done this? I need to test something and thought I would give this a try... tia -comb...more >>

hi, i know there are a variety of 3rd party products that can accomplish this but am curious if anyone knows of a way to accomplish this using sql? thanks....more >>

I thought there is someone at Microsoft checking the managed newsgroups and helps MSDN subscribers in trouble. Please feel free to look at, discuss and answer to my post on 2005-05-21 conserning out replication problem (unresolved yet). When we pay for our MSDN subscription there was no 2 ...more >>

Hi all, Maybe I'm being a bit thick, but here goes. I have merge replication set up between TableA on different databases (say X and Y). X and Y are on different servers on different physical machines. If I run (in Query Analyser) an insert statement that inserts onto X.TableA, all is w...more >>

When does the distributor_admin user come into picture ? ...more >>

Hi, We are running SQL Server 2K, replicating bi-directional across a private 3mbps pipe, with both nodes clustered on Win2K. We are experiencing a replication problem and it appears to be stemming from SQL Server turning updates into deletes and then inserts. According to the document...more >>

Hi folks, We are having issues with restores of our production databases into our test environments. Our production environment is SQL server 2000 sp3 with merge replication with 3 publications using automatic identity range management. The problem we're having is that when we try to res...more >>

Hi, Apologies if the answer to this is obvious, I'm not a SQL expert! We've got a W2k3 cluster running SQL 2000 Enterprise edition. I'm investigating the possibility of replicating this back to a standalone, SQL 2000 Standard server. Is this possible, or is not recommended to mix clust...more >>

How to avoid removing primary key on subscriber's database, i mean when i configure Transactioanal replication from one server to another with same database, (publisher to subscriber) at subscriber's database all primary keys disappear, WHY ?????????????????? I have primary key like identity a...more >>

Hi All, I'm grappling with the issue of rolling out SQL changes to multiple (150) machines deployed in the field. These machines are joined via a slow 64K WAN. How do you reccomend I deploy scripts in the field? I'm toying with SMS, but am unsure of how to deploy the packages. Is some ...more >>

Hello everyone, I just noticed that the "guest" account gets created by default on the Distribution database, whenever a server is made as distributor. Will this not create any security issues? Is this account really required here? Thanks. Aramid...more >>

Hi, Is it possible to avoid a subcriber from having a table replicated on it? Thanks Vivek ...more >>

Hi : If I want to do the follow : I create 2 database in localhost one is dev_db one is clone_db Where dev_db have data in the database, but clone_db is just a data structure but need to synchronize with dev_db schema. If I add table in dev_db , clone_db will auto add same table structu...more >>

I have a strange scenario where data is replicated from 1 publisher to 2 subscribers but somehow MS_replcommands is growing although distribution cleanup job is running every 10 mins. The subscription expiration time is set to 14 days. CAn anyone suggest anything that would help in cleaning up t...more >>

Is it possible that when i configure the the replication via Enterprise manager wizard not add uniqueidentifier column . I have in tables primaries key not identity Thanks -- Message posted via http://www.sqlmonster.com...more >>

When i configured replication by default SQl Server (2000) use the Queued Updating what does it mean "changes queued at the subscribers until they can be applied at the publusher" ?? Thanks -- Message posted via http://www.sqlmonster.com...more >>

Dear All, I've managed to get once a day snapshot replication working between 2 hosts, but only once. The first run of the publication and the subscription worked fine. The next night the publication worked okay but the subscription failed within a few minutes with the error: The proce...more >>