Hi everyone. i'm using sql database 7.0 setup for merge replication.suddenly i found out that the "Agent History Cleanup:Distribution" had a red x mark.When i examined,it shows that the agent did not run on its specied running schedule.Even if i run it manually,still it won't work. When i che...more >>

If I have an existing 64bit P2P transactional replication setup, can I join a 32bit machine without any expected problems or does it also have to be a 64bit machine? Any direction to resources would be great as well. Adam P. Cassidy ...more >>

I've heard that there was a change in SQL2K5 in regards to what version of SQL-9x is or is not supported. Can anyone directed me to some documentation that covers this? thanks, BD ...more >>

We are using SQL 2K with sp4. We are using Push method and both publisher and distribution db are on the same server. Recently we have quite a few deadlocks involving a replication's sp such as sp_MSupd_xxxxxxx and some select statement from our application. We have deadlocks from time to...more >>

We are using SQL 2K with sp4. Our replication is using Push method. Both publisher and distribution database are on the publisher server. Once in a while, our distribution agent is getting a timeout and the message is "The process is running and is waiting for a response from one of the ...more >>

--This script builds a script to drop articles from replication in transactional publications --It will build the necessary replication procedures and parameters to remove articles from replication --Instructions --Either hard code the where clause criteria or have it look in a table you ...more >>

Hi, We are developing SQL Server Merge replication. We have one publisher at our head office and 30 subscriber at different locations. Our publication server name is PUBLICATIONSERVER. And all off our subscriber have same name: SUBSCRIBERSERVER. We can't change subscribers server na...more >>

Looking for a good set of instructions on how to replicate with a Distributor in 2000 and a Subscriber in 2005. Looking to do continous transactional replication. -- Message posted via http://www.sqlmonster.com ...more >>

We have recently migrated (into a test environment) our RS2000 DB per the microsoft migration instructions into RS2005. When a history snapshot record is requested (Via ReportManager), we get an internal RS Exception... w3wp!library!1!11/13/2006-11:35:39:: i INFO: Call to GetPermissi...more >>

Hi everyone has anyone come across / developed a way of transforming the commands in MSRepl_Commands so that, for instance, and Update becomes a Delete or Insert? thanks in adveance for abny assists! ...more >>

Hello All, I am a newbie dba and need some expert advice on one of my development scenario I am currently struck with. I am in process of designing a reporting solution for my company. It is going to be a web based intranet thin client multitiered application using sql server 2000 and ..net pla...more >>

Hi I have script to manually create a publication and associated articles for transactional replication and, for various reasons, am using manually created views on my publisher and custom stored procedures on the subscribers for insert operations. The articles are added using @type = 'logb...more >>

I tested replication performance on slow network channels, for SQL2k and SQL2k5. And quite disapplointed by SQL2k5 results... Network channels were simulated, ping time 200 ms between distributor and subscriber, unlimited bandwidth. I tested how many transactions replication can deliver to sub...more >>

Hi, My publication has a large table (about 1GB) and snapshot agent times out! Then its status becomes 'retrying'. I have another copy of this DB that this table is smaller and the snapshot agent succeeds. The agent does not reach to bulk copy phase, it fails while 'preparing...'! Any help w...more >>

Greetings. I have several machines that have two merge pull subscriptions for two databases. One subscription is set to continuous, the other subscription is set to pull every hour. The publications are set to drop subscribers if they don't synchronize within 14 days. This has been in pro...more >>

Hello all, Our log reader agent is failing at times with the error "The process could not execute 'sp_MSadd_repl_commands27hp' on 'DistributorServerName'... We have custom distribution agents that have -CommitBatchSize = 500 and -CommitBatchThreshold = 1000... I'm also noticing that ...more >>

What replication parameter sets the interval in which data in the conflict tables is deleted in SQL Server 2000 SP4? The data in my conflict tables appears to be deleted every night. ...more >>

hi, i am trying to add an oracle publisher but i get the following error TITLE: Distributor Properties ------------------------------ Oracle server instance 'PS4289' cannot be enabled as a Publisher because of the following error: ------------------------------ ADDITIONAL INFORMATION: ...more >>

I have created Transaction Replication. Nearly 100's of tables there in my database. I have created Recordid (identity) column with primary key in each table and all are incremented by 1. Front End application in VB6 is 100% dependable on this column. Changes in this column may spoil my wor...more >>

I have developed a windows vb.net application which reside on users laptop and uses data from local msde database. From time to time the users can connect to a main sql server via VPN and do a merge replication with subscribtion invoked from their windows application. Problem is that the mai...more >>

Subscriber is on a separate network, and will never be able to directly access the Publisher. No ping between these 2 servers, no nothing. However! The Distributor can "see" them both! That saves the day, right? In Transactional replication, why would the Publisher need to talk to the S...more >>

I wish to add a col to a table I have published for merge replication. When I attempt to do this I receive errors in regard to the rowguid col that was added when creating my publication. Do I need to drop the publication before adding col ? Or is there another way out of this ? ...more >>

I think my distribution database blew up in size a long time ago for a specific problem, and I don't know if its large size (34 GB) will cause other problems. Is there a way I can flush out old irrelevent data and then shrink it to a smaller size? The published DB is about 110 GB and has pull su...more >>

I'm trying to setup merge replication and get the following error from the snapshot agent after I've finished the 'New Publication Wizard'. This doesn't make sense to me as it is an automatic process. Also, it looks like it is complaining about a 'dbo.MSmerge_cont...' view which is a view create...more >>

Hi i am running SQL 2005 and i have a merge replication. Sudently when i am trying to insert a new record on a table i am getting this Error. Error 2812 Could not Find Store Procedure dbo.MSmerge_expand_sp_A2F....... Can anyone help please Thanks Savvas Christodoulou ...more >>

The distribution cleanup job that runs for our transactional replication on sql server 2005 fails. The job is: EXEC dbo.sp_MSdistribution_cleanup @min_distretention = 0, @max_distretention = 72 The Error is: Msg 20015, Level 16, State 1, Procedure sp_MSreplremoveuncdir, Line 83 Could...more >>

When configuring my SQL Server as a distributor I get the following error: Error 14113:Could not execute 'copy " C:\Program Files\Microsoft SQL Server\MSSQL\DATA\DISTMDL.MDF" "C:\Program Files\Microsoft SQL Server\MSSQL\DATA\distribution.MDF"'. Check 'instdist.out' in the install director...more >>

Hello I would like to ask something about filtering Rows on a Merge Replication and about Parent-child table relations. I had one filter that on a Parent Table that the filter was depending on the Child of that table. For example I have one table called Accounts lets say with 2 columns A...more >>

i am facing problem in pulling subscription. We have 15 branch offices all over the World. Database replication through internet is must for our company. My main Distributor and subscriber machine is same in India,Mumbai. Local Network Name is (SERVER) and Static IP is (xx.xxx.xxx.xxx) Whe...more >>

I've had a look at peer-to-peer replication. Below is my requirement: - my web application does a lot of read & write to the SQL 2005 database - my code has been written in .NET (not that it makes any difference) - i need to implement some load balancing by having two sql servers - both sql s...more >>

The background: I am designing a replication topology with one "head office" database publishing to 1-100 "branch" databases. Each branch database contains a partition of the head office database, in other words just the data belonging to that branch. To enable this I must create a public...more >>

Are Oracle and DB/2 the only two hetergenous subscribers I can have? I need to replicate to a sybase database. If it is possible, what versions of sybase are possible? Thanks in advance. ...more >>

Does anyone know of a good set of guidelines to follow, after running DBCC Showcontig on a publisher of replication and DBCC reindexing is called for? What are the pitfalls and things to watch out for? I can't afford to make a mistake since there are three servers involved and it's in producti...more >>

Hi all, I am trying to do a merge repl with sql 2005 on both ends. I have a decent size db of 1.2 gb. I had the replication working ok before. But due to some updates I had to apply to a program , I had to break replication. When get the snapshot made and the try to sync I get: "The schema sc...more >>