Dear sir, what should i do if my replication running but no one of data is upload or download and only say "connecting to subscriber "WDATACENTER"" for long time. and for your information that the replication is no problem before, but since 2 day ago it going problem. can you explain to me ...more >>

I am trying to find an automated way to determine that transactional replication has distributed all transactions to it's subscribers. What I am trying to do is drop a subscription on a scheduled basis, but I want to ensure that all transactions have been replicated before I do so. What is the...more >>

When the Agent statrs a job it terminates itself with: [LOG] Exception 5 caught at line 191 of file ..\src\refreshr.c. SQLServerAgent initiating self- termination is it a bug of the ITALIAN SQL server 2000 versio? Anyone could help? Thanks Paolo...more >>

Hello, Does the distributor_admin login need to have System Administrator privileges? I am trying to audit and clean- up our SQL Server logins and was wondering about this account. Thanks! -Jose...more >>

What is the difference between commands and transactions that are delivered by the log reader agent to the distributor ? ...more >>

Hi, Can anyone tell me where is the parameters stored that are set for the Replication Merge Agent. (e.g. QueryTimeOut, Output etc.,) Thanks Anand ...more >>

I know that an existing article can be dropped and added to a subscription without deleting using sp_dropsubscription and sp_addsubscription as opposed to the GUI My question is can i add a new table or sproc to the current subscription ? I am using SQL 2000 ...more >>

What does replicating UDFs, views and indexed views buy us if the subscriber is gonna be used for read only ? And even if the subscriber was used for applying inserts,deletes and updates but had created them manually on the subscriber, what addition does replicating them buy ? I am using SQL ...more >>

I am attempting to replicate between a sqlserver 7.0 on NT and a msde 2000 on win2k. I have set up the sqlserver machine as the publisher and have attempted to push a subscription out to the msde machine (through a firewall with 1433 open). I am using ip addresses in sql enterprise manager...more >>

Hello: Is there a way to drop repl coulmns with default values, (so that it propagates to existing subscribers) Can you safely get rid of the DF_ object without breaking repl? Note: we do not want to reint subs, rebuild the pub etc... Thanks, Scott Kramer EXEC sp_repladdcolumn @sou...more >>

Hi, I have read conflicting information from different sources regarding domain accounts used to run SQL Server Services and replication. Does the account need to be a local administrator? Some sources say yes and others say no. If not, what permissions must it have on the server for ...more >>

Hi, I recently started doing transaction replication for our production server. Distribution Agent is scheduled to run at a certian time every night. Now, I am getting an error, which is: " Cannot insert explicit value for identity column in table 'tablename' when IDENTITY_INSERT is s...more >>

Hi! I hope anyone can help me with this very important problem! Since configurig one subscriber in our merge replication scenario to a subscribing publisher we get a lot of merge conflicts type 10 reason code 2. Because we have the german version i translate the reason text as meaningful as...more >>

Subscriber: WinXP with MSDE2000sp3 Publisher: Win2000 with SQL 2000 EE sp3 Distributor: on same machine with publisher I have been able to apply an initial snapshot from a removeable media to the subscriber, but it doesn't appear as if I can do so while the subscriber PC (a laptop that wi...more >>

Does anyone out there have any experience with Replication over vpn between 2 offices (T1 line). I'm wondering if setting up transactional rep for a db ~17gb in size would work consistently, or if log shipping would be a better option. Trans logs for a typical weekday are around 300-500mb/...more >>

sql2k sp3 I was wondering if you could point me to a good white paper or the like on log shipping a replicated db and then "failing over" to the warm standby box while retaining all the replication settings? According to BOL I will also need to be backing up the distribution db. Which is...more >>

I am currently in charge of designing a failover plan for a remote distributor server. Minimal downtime is critical, because we have updating subscribers so downtime on our distributor server needs to be avoided at all costs. I am trying to determine a way to failover the distrubtor serv...more >>

I have simple bi-directional replication set up on two servers. A ---> B A <--- A Everything is working fine except i cannot figure out how to make a table change (like adding a new column) to a table that is in the merge job. SQL Server will not allow changes on a table referenced...more >>

Hi all We are planning to setup replication between SQL server 7 publisher and SQL 2000 Subscriber. We heard that eventhough BOL says no problem with that the agents fails without reason or get disconnected. I that true and if so please let me know how i can resolve them Thanks...more >>

I have Trans Replication going on now with the help of experts from this forum. I have a question cause somebody pointed out me this! My publisher is on West Coast while the subscriber is on East Coast - 3 hour difference!! Do I need to synchronize the times for replication? Is it necessary? ...more >>

I have Trans Replication going on now with the help of experts from this forum. I have a question cause somebody pointed out me this! My publisher is on West Coast while the subscriber is on East Coast - 3 hour difference!! Do I need to synchronize the times for replication? Is it necessary? ...more >>

Merge Replication in SQL Server 2000 A ---> B A <--- B I have servers A and B Make a publication in server A Make a push subscription from server A to server B ok changes from server A are updated in server B My question is that if I need to make a publication in server B with...more >>

I've searched the web and it seems the answer is. "Replication is not the proper solution for handling schema changes". Is this true, and if so what is the best way? I've seen .bat files as an option. Thanks in advance, Dan ...more >>

I have: 3 servers (1 - distributor, 1 - publisher, 1 - subscriber) All win2k server, sql server 2000 sp3 I trying to enable the publisher server as a publisher. When I go to the distributor server then publisher and distributor properties dialog, select the publishers tab - the publi...more >>

Hi, Which are the tables, stored procedures and triggers involved in the replication (merge replication) SQL Server 2000 SP3? How to check all that for inconsistencies? How to clean them manually safely? I have a problem of inconsistency in my replication metadata. The large history is the...more >>

sql2k sp3 I am using Log Shipping with Transactional Replication. The Publisher transfers tlog backups to a Backup Publisher. The goal is to be able to switch over to the Backup Publisher if the regular Publisher ever goes down. So to simulate all this, I restore the Backup DB on the Ba...more >>

Hi! We have transaction replication from MSSQL7 SP3 on W2K to Sybase12 on HP. Distribution agent fails when one of replicated columns of varchar(16) type contains empty string. If there is at least space it is OK. I think this is a bug. Is there a fix that addressed this issue? Thanks...more >>

Hi Everyone I have a pull subscription on SQL 2000 SP3 which fails with the error message "The process could not connect to Subscriber 'JOE'". However, the subscriber SQL Server is called 'MOE' not 'JOE', and furthermore there are no SQL Servers on the network called 'JOE'. I create the subsc...more >>