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 >>

Hi there. I got 2 SQL server 2000 located in 2 different location. I want to setup merge replication between them via dial-up from subscriber to publisher's RAS server. For your knowledge, DC, RAS server, SQL server(Publisher and Distributor) are in one server. Can I do this? Is the b...more >>

Hi All: I found a KB article on removing replication in SQL6.5 http://support.microsoft.com/default.aspx?scid=kb;en-us;170481 Is there a similar document for manually removing replication in 7.0 I need to remove a transactional replication that I cannot access through EM. Regards HS ...more >>

When I tried to delete a subscription I received the message Error 644: Could not find the index entry for RID '168fa920100' in index page (1:1666), Index ID 0, database 'msdb'. I tried to delete this one since the original publisher and since the suscriber and I received a similar messag...more >>

I get the message> The subscription to publication "yyy" is invalid I am trying to do a merge replication in SQL server 2000. What might be happening ? thanks fili sosa...more >>

I am using SQL Server 7.0 SP4. I have transactional replication going from SERVER1 to SERVER2. Sometime over the weekend replication went down when the distribution agent timed out. When I came in on Monday, I tried to restart it which usually works. However, I started getting an error sayi...more >>

We've got a merge replication. I have one Publisher and one Subscriber. I've made a pull subscription to a Publisher. I've got into trouble with subscription sync: when syncronizing merge subscription with BIDIRECTIONAL mode data in Subscriber database are deleted. I need to store the subscr...more >>

Can I restore a backup of a replicated database? I created a backup of a replicated database. I need to run some procedures that are going to aler the data in my tables. If I mess up I will need to restore the DB back to before I start. Is there anything I need to concider before doing...more >>

I want to delete tables from my database but a message tells me that it can not be deleted because it is being used for replication. However, I do not have any publications or subscriptions because I deleted all of them. How do I delete the tables that were in those subscriptions?? t...more >>

Hello all, I was wondering if anyone knows of a configuration setting to allow my publisher and distribitor to automatically reconnect to the subscriber if the subscriber has gone down. I leave the subscriber down overnight, and was wondering if when it comes back up the databases can ...more >>

Hello,=20 In a merge replication between SQL Server 2000 (PC) and=20 SQL Server CE (dispositive) how can i resolve conflicts? for example: - Table: Products - columns: Id, Name, Price, Date, rowguid. - custom procedure resolver: (This proc must exist at=20 the PUBLISHER and in ...more >>

Hi there. I have two SQL server 2000 located in 2 different domain (AD) and 2 different places. I want to replicate both server via telephone line. Is it possible? Thanks and regards, Victor...more >>

Hello, We are using SQL Server 2000 to replicate data among 2 servers. The problem is that I can not remove subscriptions from one of the servers, because we re- installed the SQL server where the publications were created. Since the publications do not exist anymore, is there a way to ...more >>

We have a set of 14 servers we replicate out to. We're using transactional "immediate" replication of a single table from 1 server to all the others. The table has about 1500 rows, 4 columns of 3 varchar(255) and 1 text. This table gets a 1 or 2 rows edited, added or deleted once or twice a day....more >>

I have a couple of questions regarding Transactional Replication. -When a snapshot is taken of the database and replicated to the subscriber, Does any added columns, tables etc are also replicated. -Second question is that, Is everything including schema and data is transferred to the subs...more >>

Hi, I have three development boxes to try LOG Shipping, Server A-SOURCE (had standard SQL Server) upgraded to SQL Enterprise server and ran instls.sql for handling LOG Shipping as per http://support.microsoft.com/default.aspx?scid=kb;en-us;295306 Server B-DESTINATION (had developer edition) upg...more >>

Hi! We are replicating 5 tables from mssql7(publisher) to sybase server(subscriber) in two different subcriber databases. Sometimes replication is stuck because replicating transactions are not complying with integrity enforcements on Sybase side. In that case transaction is stuck in dis...more >>

Hi, i have a SQL Server 7 SP2 under WinNT 4.0 SP6, and I hace problems with the replication; after to do the uploads, show a message : "The process could not enumerate deletions at the Subscriber.", and "Timeout expired". thanks Manuel ...more >>

Hi I am trying to re-create a stored procedure that is being replicated. I am trying to drop it and re-create it but it wont let me because of the replication. How can I remove the SP from the replication? I do not need to replicate it anymore. Thanks, Joe...more >>

I have transactional replication with 'immediate with queued updatable' subscription (in default mode of Immediate updating now) between 2 SQL 2000 server running Win 2K OS There was an update in Subscriber. I got the following error. DELETE statement conflicted with TABLE REFERENCE constr...more >>

Hi, I have a scenario in which there 2 log reader agents and 2 distribution agents exist (ie they show up under the replication monitor node in EM) without their SQL Server Jobs. I removed replication from 2 databases using sp_removedbreplication, but somehow that didn't remove the lo...more >>

Hi, I need to push DB structure changes made to a local database to a live database of customer. Now I do it manually. But it takes a long hours!!! Can anybody point me to the more easy way? Thanks ...more >>

Hi: I've got a replicating database, this worked fine, until one day whe created a new subscription an started to throw the "207" error, we deleted all the current subscriptions and publications, re-created them and went back to work allright, why is that??? someone has a good explanation...more >>