I have a SQL server running on a remote location that has a different port enabled to connect other than the default one, which means that when I want to register I have to specify the port number as well eg. Server1\InstanceName,4001 . I am trying to carry out merge replication between the ...more >>

OK, with a tip from ChrisR I got the first problem fixed (I hope). Now, I have another problem. I have created a pull subscription on a second server, say SERVERB, to get the data from the first server, say SERVERA. Every time I try to run this pull subscription I get the following message: ...more >>

Hello, When conflicts arise, we can use the conflict viewer. We have checked the box that says to log them for future use. Help says they go to the system tables. I am trying to find conflict information from several replications ago, but can't find them. Is there a certain system table...more >>

With the following code I get the error Method 'Initialize' of object 'ISQLDistribution' failed. The .Status at this time is "Connecting to Subscriber 'MYCOMPUTERNAME' " I have a SQLDistribution Object called sqlDist. The error occurs on the .Initialize Can anyone help? /* START CODE SEC...more >>

Hello, I have a couple questions regarding Snapshot replication. Ive looked at the full docs (v. SQL 2005) and understand everything except Im not too clear on these. 1. While a snapshot of a publication is being applied to a subscriber, are the replicated tables available in read-only ...more >>

Architecture : 1 Combined Publisher and Distributor. 4 anon (pull) subscribers to a Merge publication. All SQL instances are SP3. Details : Subscriber A and B get the same initial snapshot. Subscriber A regularly synchronises, updates are applied. Server and subscriber A data consistent. S...more >>

Hi, How to setup replication properities when lots of table have contstrains and relationship? I am setting a snapshot replication, but the push task failed with PK and FK constrains. Please advise. -- Best Regards, Lynn...more >>

Hey folks! I am trying to set up a snapshot replication. The publisher and distributer are the same machine. Every time the snapshot agent runs I get the following error message: The publisher login of the snapshot agent must be a member of the sysadmin role or db_owner role. SELECT per...more >>

Hi I need to globally update certain tables over multiple databases. I have about 300 tables in each database and only a handfull will be the same. Can I do this with replication? Can you setup replication for only certain tables?...more >>

I am getting the following the error trying to synchronise a subscriber using merge replication. The schema script 'exec dbo.sp_MSsetlastsentgen '299424F6-B38D-4CE7-840E-B941925A7F2D','485','5FC5F1FA-F9EF-4207-9560-06CF70 304024'' could not be propagated to the subscriber. I have seen the kno...more >>

Hi, I am dealing with merge replication. The following error occured several times since last 1 month. The merge process could not perform retention-based meta data cleanup in database 'databasename'. (Source: Merge Replication Provider (Agent); Error number: -2147199467) ----------------...more >>

Hello: I have the following situatioin. A few months ago, I setup a secondary SQL server with the same schema and data as the primary. But that server was shut down for a few months. Currently, I am thinking to set up replication (transaction). Since the database is rather huge, I thi...more >>

Un unexpected error occurred while trying to launch the Conflict Viewer. Nothing more and of course, no conflict viewer.... Any idea how to fix this? Michael...more >>

Hello; I’ve run across another issue with replication, I am pushing a publication out to a remote server. Looking through the history of the distribution agent, I see the scripts are applied, but once they are finished, the agent fails with the following error message: Could not find serve...more >>

I am having problems when attempting to publish my database. When I try to set the automatic identity range handler, the checkbox is dimmed out. I am using SQL Server 2000 and my subscribers are using Windows CE. I have set all the indentity fields to INT (2). Everything seems to be in order,...more >>

What do I have to do in SQL 2000 to replicate permissions?? ...more >>

Hello, I've been trying to set up an msde database for replication. I've fixed some problems but I can't get past thisone. I've read every topic about this error but nothing worked. I've set up msde with 'setup SAPWD="***"', I didn't set the instance name or any other parameters. Thanks....more >>

My invoice header table has a primary key of Location# and Invoice#. If a subscriber does the following… Creates invoice with the primary key of Location 4, Invoice 100. Replicates the data. Deletes the record and recreates it. Replica...more >>

I'm looking for some docs to instruct me how to setup log shipping in a SQL 2000 Standard environment. Thanks ...more >>

Hi, Is it possible to setup full replication of a database to run nightly as well as partial replication of only a couple of tables on an hourly basis? Thanks, Jason ...more >>

Hi, I have Transactional replication setup where at PUBLISHER 90% of my tables have PK Auto Increment. Which replicated to SUBSCRIBER. Publisher(Publishing database) get updated by Importer(In-House tool) Subcriber get updated by Publisher as well from Website and needs to have PK Auto ...more >>

hi all, Need urgently, I am using sql server and vb.net for pocket pc programming. I am using merger replication with dynamic filter with host_name attribute. I got 3 questions 1) Is it needed that we have to create dynamic snapshot for the dynamic filter . 2) If so i created dynamic snaps...more >>

Hello all, Is there a really good book on replication that you can all recommend? I own many SQL Server books but none of them cover the subject in detail. Or do you recommend Books Online is my best option? Please advise. Thanks! Johnny...more >>

hi all... I have a little problem. "18483 - could not connect to server 'Newname' because distributor_admin is not defined as a remote login at the server." ...more >>

hello everyone, i've been trying to set up a long term solution replicating data from our production database into our development and staging environments. from what i've seen, the simplest way to do this is to restore from back up. unfortunately the production devices are on a remote network...more >>

Hi I've created a replication using stored procedures.but I have a problem, after I run the stored procedures , the synchronization doesn't start, and I must initialize it manually. what can I do to start the synchronization by stored procedure? Thanks Tajik ...more >>

Dear Members Is there a way 2 update the table structure that is part of an article without deleting the replication ? Best Regards Shahid Saleem *** Sent via Developersdex http://www.developersdex.com ***...more >>

I am using sql server 2000 workgroup edition. when trying to replicate data between 2 servers I am getting tha error "Could not find stored procedure 'sp_MSins_tablename'. ...more >>

Hi all... While setting up my merge replication through the replication wizard in I read that the use of HOST_NAME() in the dynamic filter returns the Subscriber's Machine Name. How to get host_name() value in .net code can anyone give or suggest the code how to write to get host_name an...more >>

I've got a couple of replicated databases and I've found myself in the position of wanting to move my distribution database to a different storage volume. Enterprise manager considers it replicated, so I can't just detach it, copy and reattach. Anyone know of a good way to do this? Thanks...more >>

I created a transactional replication publication and pushed a subscriber, and that works fine. I deleted existing push subscription in the publisher with enterprise manager, and also deleted automatically generated replication jobs related to that push subscription. I noticed that the push s...more >>

Hi all, I am rather new to MS-SQL server(which I find extraordinary, it works really well). When I set up a transactional replication up, I realized that it is not possible to replicate any of the system tables, am I wrong? If one can not really replicate teh system tables, then talking a...more >>

I need to pull the schema only with no data, then push the data back without deletes on the publisher, then delete the client data. Next time these deletes would not be pushed up. Only new data. ...more >>

I'm trying to filter an article by a Int field with the following ID=CONVERT(int,HOSTNAME()), but ID=CONVERT(int,'1') works. This used to work in previous versions. Thanks Mike Smith...more >>

My client uses a third party application that uses a SQL database without any primary key indexes. Since I can't use the inherent SQL Server replication, is there any third-party software of any kind that can do it? I suggested log shipping to my client so the database could be "replicated" a...more >>

What happens to subscribers when you do a RESTORE (full or transaction log) of a publisher? Does Agent "restore" the subscriber, or are the changes "replicated" to the subscriber. Basically, I want to know if users can remained connected to a subscriber when the publisher is restored...and how...more >>

I need to make use of replication to merge two remote databases with one central database and then update the two remote databases with the data on the central database. What is the prerequisites for setting up replication? I want to use C# for the merging. What do I need to do, because I've b...more >>

We use SQL Server 2000 SP4 with merge replication enabled. The master site replicates all changes to at multiple subscribers, but we encounter some problems due to deadlocking issues. Some actions produce a lot of new data that must be replicated. The table, in which the data is inserted, h...more >>

Hi, The SQL Server 2000 transactional replication does not automatically replicate any publication DB schema changes except the addition of a column to a table or removal of a column from a table. Would you agree that this fact makes impractical the (snapshot-like) replication of other public...more >>

Hi Guys, I have a little problem. I've recently set up merge replication between two databases that were synch'd..no problem. This morning the merge agent went suspect..shouldn't have been a problem but I changed the Timeout in the profile. Now the agent was restarted and it is hangi...more >>

(Please, see http://vcraft.com.vn/mergerepl.JPG for detail) I have 3 servers: ServerA, ServerB, SeverC. Now, I need to deploy these servers in a interprovince merging Replication. It means: ServerA is publisher of ServerB (subscriber of ServerA) AND ServerB is publisher of ServerC (subscriber ...more >>

how to delete rowguid column from all the tables after I remove the replication... -- Posted using the http://www.dbforumz.com interface, at author's request Articles individually checked for conformance to usenet standards Topic URL: http://www.dbforumz.com/Replication-delete-rowguid-column...more >>

Hi everyone! I'm completely new in SQL Server 2000 Replication. I have two questions: 1. I have 3 subscribers and 1 publisher. I use push merge replication. The distributor runs on publisher. The publisher and distributer server name is NEON, the subscribers name are GENESIS,PLUTON and VEN...more >>

The process could not connect to Distributor SERVER-SQL'. The step failed. [SERVER42000] (Error 14151). The step failed....more >>