I see a parameter in the "high volume server-to-server" merge agent profile named QueueSizeMultiplier. Can anyone tell me... The purpose of this paramter The possible values and their meaning....more >>

I posted this in the programming forum and got new no response, whereupon I realized this post probably belongs here: "I just got a new job and they claim that some of their (SS 2000 SP4) transactional replication processes get blocked by users. They've charged me with building a script t...more >>

Hi, I want to add new publication in the same database and same server. Now I have question regarding log reader agent, can I use different log reader agent and do I need to do that? thanks. ...more >>

Firts we create 12 publication, each with many articles, all initialize and sincronism ok. After that, we just use one aplication to manipulate data at publisher. Twice error 18805 appear. The Log reader can not execute and this message become: The process could not execute 'sp_replcmds' on '...more >>

I have a SQL 2005-2005 Express Merge replication. Articles with FKs. Added a new subscriber, when I initialize it, some tables are updated more 190 times. For example, customer table has 100 records, however the initialization inserts 100 and update 19000 rows. It makes the initialization too...more >>

I am curious if a "session" for merge replication is a transaction. If I see 100 actions in the Agent History and the last one is "the process could not enumerate changes at the subscriber" due to General Network Error (dropped connection or whatever), did those 10000 data changes get commi...more >>

I'm trying to set up transactional replication using SSMS. I had no errors creating the publisher and distributor but had warnings when the subscription create was running saying that another sa process was running. I'm new to this and do not know how to get the snapshot to run or see why it ...more >>

I'm new to replication and maybe I'm missing something. I set up replication from one server to another (push). The replication is working fine every hour, but I have to start the snapshots manually. If I don't, no replication takes place, because there are no changes in the snapshot. I ...more >>

Hi, Is there a way where I can add a table to an existing publication in SQL 2000 (both publisher and subscriber) and get the transactional replication to work without generating the snapshot of the whole database ? There are few tables who have columns omitted from the existing publication...more >>

I am trying to setup a merge (push) replication to a server/database in a remote network. I created the publication and connected to the remote network using VPN but cannot register nor see the remote sql server. In sql server 2000, I was able to register the server in my Enterprise Manager (...more >>

Does anybody know what could cause this error: The schema script '\\SERVERP\ReplData\unc\SERVERP_ANIL_ANIL \20070626175153\ZEZALOGADATUM_1.sch' could not be propagated to the subscriber. (Source: Merge Replication Provider (Agent); Error number: -2147201001) ---------------------------------...more >>

I set up a transactional, pull publisher, distributor and subscriber last week on a development system and all worked fine. Then, I did the same set up on our production system and it is not working. When this was started on Thursday night the distributor would not start. I was not here Fri...more >>

Hi, We have a product that configures on SQL 2000 and also configures the replication. We are in the process of doing R&D on SQL 2005. Following are my machine specifications OS Type : Windows 2000 Server (SP4) SQL Server : SQL 2005 When i try to create a publisher and a subscriber, on th...more >>

Hi, I am using MCALL for updates sql statement, I know MCALL only replicates the changed columns, however is it possible to force a certain column to be replicated even there are no changes to it? Thanks in advance. ...more >>

Currently, we have many MSDE instances that subscribe to our main server. Morning, we have to re-init whenever there's a failed subscription. Is there a way or script to automate the reinitialization? Also, how can we indicate it to use the current snapshot or generate a new snapshot? Thanks...more >>

I'm experiencing an intermittent issue with merge replication after upgrading one of the subscribers to SQL 2005 Express from MSDE 2000. Here are a few details about the environment before I describe the issue 1. Originally was SQL 2000 Standard Publisher with MSDE 2000 Subscribers all SP4 2...more >>

Hi, I have the following setup: OracleDB SQL2005 SQL2005Express There's a transactional replication between OracleDB and SQL2005; and there's a merge replication between SQL2005 and SQL2005Express. Changes made in OracleDB properly synchronized into SQL2005, but for some reason Mer...more >>

I have a database where some tables have the IDENTITY = YES. If I copy or export from ServerA to ServerB, the IDENTITY gets set to No. This has to be a simple problem. How is it fixed? ...more >>

Hi, I'm trying to run the wizard to setup replication on a SQL Server 2000 SP3. Entering the parameters goes without a problem but when executing the script I'm getting an error 14113: SQL Server Enterprise MAnager could not configure 'XYZ' as the distributor for 'XYZ'. Error 14113: Could...more >>

I use merge replication on a SQL 2000 SP4 with dynamic row filtering. It has been working fine for years. This was the filter query: SELECT <Publizierte_Spalten> FROM [dbo].[Benutzer] WHERE [Benutzer].Hostname = HOST_NAME() Now I wanted to extend the functionality of the filter query with...more >>

I don't think I ever resolved this issue & now I am quite concerned = about my growing MSRepl_Commands table. It has over 9 million rows. What steps can I take to reduce the number of rows in this table? Thanx! --=20 JUDE...more >>

Good Morning, I have a dude with a new SQL implementation. The scenario is a Central office with an SQL server and 10 branch offices with sql server too. I need to replicate branches data Base with the central sql. All the branches could see the same DB. It is possible to implement with...more >>

Hi all, Our setup is pretty simple, one transactional box, a remote distributor, and a reporting server using one way transactional replication, push subscription, no immediate updating. (All boxes SQL 2005) Around 3am the sql server agent died on the distribution sever with this message in t...more >>

Hi, I tried to implement Snapshot replication and collected all the test results. Finally dropped all the replication stuff from server,but the host DB is still showing as "Shared" and i need help to remove this.Not sure how to proceed. Any help will be great. Thanks, Shyam...more >>

replication is failing with mssg "Error at parameter 34 during datastream processing of parameterized command." any input what could be the reason for this failure and what action should i take to sort out this issue ? From http://www.developmentnow.com/g/114_2003_7_22_0_0/sql-server-replication.h...more >>

Hi How do you clear out the distributor? I am able to clear down the log using sp_repldone, sp_replflush if there are large errors. However, how do I clear out the distributor assuming that it's trying to execute a sproc that might not have been replicated? Thank you Simon ...more >>

Hi, My questions is during replication from sql to sql it will create stored prodecudres but from sql to oracle iinstead of stored procedure it will only create sql stmt so during this time it is not using autoparameterisation for simple delete stmt(adhoc stmt),is there a way that we can use...more >>

I have just created a publisher, distributor and subscriber on 2005 using transactional replication. The creation process went fairly smooth but when I right click on the local subscription and select View Subscription Status it shows: "The job failed. The Job was invoked by User sa. The l...more >>

Hi, I need help/guidance setting up replication across dbs. db1 has the same tables as db2. tables have the same fields. db1 has "dbo.table" schema, db2 has "other.table" schema. I setup simple replication and db1.dbo.tables are being added to db2 as db2.dbo.tables instead of just ref...more >>

Hello all and thank you in advance: Question 1) Can I use merge replication with tables that IMAGE data type columns? Question 2) I need to add my uniqueidenity, if I add to the bottom of the column list can be sure that ALTER statement will be transparant and not lock the entire table? ...more >>

Hi everybody, I have a system of 2 PC, with installed Win XP and SQL 2000. I configured one PC as Publisher and Distrbutor, and the other as a Subscriber with a "push" subscription. The snapshot and the merge agents are running on the Publisher/Distributor. This PC is always ON for 24 hours e...more >>

Hello, I have restored a Database to Computer B from a Backup of Computer A. The backuped database was replicated with lots of Articles and subscribers. The restored Database is full of replication stuff system tables. Tables like: conflict_RTM_REPL_MERGE_Aktion_TS_S_AktionAktivitaet...more >>

Hi, I heard that simple delete stmt which deletes no of rows everytime in replication is not using came plan caching why you have any idea or is there any option that we can turn on to use cache plan.. Thanks in advance -- Message posted via SQLMonster.com http://www.sqlmonster.com/...more >>

I need to add multiple new fields to a replicated table. There are sveeral subscriptions to the publication that contains this article. Can sp_repladdcolumn be used to add more than one field at a time? Everytime I add a field using Enterprise Mgr, it takes a while to update all of the subsc...more >>

Most of my tables is dropped after they are created. I cannot tell when this happen. This include stored procedures as well. I checked the maintenance job and none are dropping tables or stored procedures. The funny part is my tables and stored procedure which is published out as articles r...more >>

Hi all, I have one out 20 merge replicaion that just hangs and never ends at step 2 which is the run agent step. I added -Output "E:\ReplStepLogs\repl.txt" -OutputVerboseLevel 2 to my run agent step of the job. In the file I get the below error over and over. I am not sure what query ti...more >>

Hi, Using sql server 2005, we've got transactional replication going between two servers. if i need to remove a couple of tables from the replication, do i have to reinitialize the snapshot every time i do that? or is there an easier way to achieve this? thanks for any help on this, ...more >>

In SQL 2000, you could just click on the orphaned agent for the anonymous subscription in the replication monitor and poof it, but I see no analagous way to do this in SQL 2005. Am I missing something? Thanks. ...more >>

There are "orphaned" subscriptions on my server (Replication folder, Subscriptions), how do I get rid of them? There are no publisher or publications, referencing these subscriptions. Thank you in advance. Leon...more >>

A database has been deleted that had publications set up and these are now causing errors in the 'Replication Monitor'. Under Replication Monitor - Publishers - SeverName - dbname we have a failed snapshot agent that says [SQL-DMO]The name 'dbname' was not found in the Databases collection. ...more >>

Hi, I would like to backup a secondary log shippping database (in restoring or standby mode). I need to use the backup as an up to date test database on the same server but don't have the bandwidth to copy the primary backups over. I've tried the backup command which results in an error sayi...more >>

Hi, i am planning to set up transactional replication for a database that sees upto 10 million transations a day. The replication is meant for disaster recovery and reporting purposes. Are there any caveats that I need to be aware of? I have been going thru the whitepapers published by Mi...more >>

I've been tasked with improving our company's merge replication performance. We are using SQL merge replication and lately we are seeing a decrease in the performance. Specifically, we are seeing more errors, retries, latency, and even missing data. I hope someone can provide insight or s...more >>

I write an application in pocket pc.Customers make sync(Merge) with sqlserver. The sync time 26-40 sec generally.The number of rows doesnt effect the time.I send 200 data to mobile device it takes 15 sec.Mobile device send 1 row to sqlserver it takes 15 sec.. How can I reduce the time? I want...more >>

I'm getting this, after upgrading from 2000 to 2005. Replication-Replication Distribution Subsystem: agent (null) failed. The subscription to publication '(null)' has expired or does not exist. The only suggestions I've seen are to dump all subscriptions. Since we have several dozen public...more >>

My question is similar to "Simplest way to move an entire database". I have to move a central publisher (win2K server) to a new physical server with no down time. The current setup is a standalone that houses it's own domain, web, database and application. I need to migrate this to a dat...more >>

I need to move a database from one SQL server to another. Is there an easy way to move everything (tables, data, views, stored_procedures....)? Thanks, ...more >>

How can i get the unc path to the default snapshot folder using TSQL? I am using Transactional replication on SQLServer 2005. I have used sp_helppublication but that only tells me whether my publication uses the default snapshot folder or not. My publication does use the default snapshot fol...more >>

Hi all, The shotshot agent is generating a snapshot, I got the error ' Attempted to read or write protected memory. This is often an indication that other memory is corrupt'. Then, the agent failed. I tried to restart the agent and generate a snapshot again. This time, it run normally....more >>

Hi, I got a new application with Access front end and sql server back-end. This application has replication features where users can directly upload their changes on the main server. I have no knowledge about replication. However, I need to maintain this sytem. Is there any article or book th...more >>