hi all, im thinking this is not impossible, but any links or tips on how to set this up?...more >>

Hi All, I'm trying to add a reference to this DLL in Visual Studio 2003 so I can programmatically trigger replication. When I try and add the reference I get the following exception: "A reference to 'C:\Program Files\Microsoft SQL Server\90\SDK \Assemblies\Microsoft.SqlServer.Rmo.dll' could...more >>

Hello, I'm currently getting the following error message when trying to synchronize my Distributor database server (Server B) to my Main database server (Server A) using a Merge publication - the publication & subscription did appear to set up correctly but on the first synchronize I see th...more >>

Hi Everyone, We had some conflicts that were not resolved, and when we wanted to resolve the conflicts, the data was no longer in the conflict tables. It just vanished. Is there something that that "cleans" the conflict data. I thought they stayed there until they were resolv...more >>

Hi Everyone, A backup of a replicated database (merge publication) was created and I need to restore that in a different server so that I can take a look at the conflict tables when that backup was created. Basically I am interested in restoring the conflicts tables. However, ...more >>

I'm trying to set up a very simple model of Transactional Replication using SQL 2000 Enterprise: Single Publisher (Distributor resides on the same box), two Subscribers with updatable subscriptions. I have no problems distributing changes from Publisher to Subscribers. However, when I try t...more >>

Hi ! Each time i try to synchronis a snapshot replcation or a merge replication, i receive these errors messages. Error messages: The process could not connect to Subscriber 'T03'. (Source: MSSQL_REPL, Error number: MSSQL_REPL0) Get help: http://help/MSSQL_REPL0 TCP Provider: Une te...more >>

Hi, I configured multiple publishers and one subscriber architecture on sql 2005 by having one publisher control the schema and indexes on the subscriber, and the other publishers only append their data to the subscriber. I'm trying to mimic a disaster recovery issue where one of the publis...more >>

I know transactional replication keep all articles in sysarticle system table. Is there any other table or views for merge articles. TIA ...more >>

Hi All, I'm trying the following using SQL Server 2005 Developer. (also tried with SQL Express and have some issue) I'm trying to use a single server as a local distributor, publisher and subscriber for a proof of concept using merge replication. According to the link below, If I right-cl...more >>

I have a very strange issue with merge replication. I recently published some changes to triggers and stored procedures. The script took less than a minute to run on the master database. On a good link (gigabit LAN) the changes replicated in about 5 minutes. However, on a 2Mb lease line it took ...more >>

is it possible to replicate 2 databases with different names on different servers under SQL server 2000? I want to replicate server A database 001 with server B database 002. Thanks. Brian ...more >>

I have a transactional replication running and it's running well. But now i'm writing a script so I can start the Snapshot Agent from distance. therefore I want to run it from the command prompt. I'm using this command: C:\Program Files\Microsoft SQL Server\80\COM \snapshot.exe -Publisher <s...more >>

I have been dealing with transactional replication a little bit and I am a bit confused with the identity column and its affect on replication. It seems like SS doesn't want to replicate the identity the subscriber. The Dialogue box directed me to set the property to "not for replication",...more >>

I have read other posts about this and the technet on MSSQL_ENG021075 but I still cannot get past this problem. What has caused this is I added fields to tables in the publisher and redid the snapshot to get them to the subscriber. The snapshot runs but when I run the distributor I cannot ge...more >>

Hello, Merge Replication, SQL Server 2005 I have got a table with an update trigger that is supposed to fire when a user updates a field. When replicating this database, the trigger fires when a user updates a field *and* when the update is performed by the replication process. How...more >>

I have a SQL 2000 box with latest service pack as a publisher and distributor. The log reader agent is not able to connect and as a result the transaction log is growing. On the other hand, there is a connection to the distrubtion database and it appears to be an orphan connection from the...more >>

Virtual SQL Server name (As registered in EM) = AZD00INT001\LBU Nodes Node 1 = AZD00INT001A Node 2 = AZD00INT001B The same Domain Account is used to start the SQL Services on both Nodes Using Management Studio When I right...more >>

I am running SQL Server 2005 SP1. I have a linked server connection with replication set up. When I run the following, data is returned, no errors: SELECT * FROM [LinkedServer].[DBName].dbo.[TableName] However, when I run the following, I get "Could not connect to server ' [LinkedServer...more >>

Hi all, Have Transactional Replication on SQL 2000 EE SP4 for some time now as follows: Publisher/Distributor is an 8 way Server 8GB RAM, RAID 1 (ldf), RAID 10 (mdf), RAID 0 (snapshot folder) Dist Agents run at Distributor as PUSH to existing Subscribers as follows Subscriber1 - ServerA...more >>

The custom procedure was created successfully on Oracle. The following is the error message that is recieved. What is really odd is why SQL Server is sending a select of a stored procedure name? Any ideas as to what is going on here? SQL> select * from sp_upd_crms_repl where 0 = 1; ...more >>

I have the responsibility of setting up SQL2000 (merge and transactional) replication of a 30GB database between 3 physical locations (within 100 miles), over 256KB pipes. I have done this with no-sync before (backup publisher to USB HD and restore at subscriber), but the downside of that is t...more >>

I want to synchronize data between Sybase ASE 12 and MSSSQL 2005. Which database should be the Publisher and the Subscriber? I only see MSSQL Publisher and Oracle Publisher in MSSQL Replication. So i made my MSSQL as the Publisher. As I was going to create a New Subscriber, I realized I re...more >>