I have a publication within a transactional replication with a push subscription. I had deleted the subscription on the Publisher through the EM. And Publisher EM showed the subscription is removed. But when I checked the Subscriber EM, the subscription is still there under the Replicatio...more >>

We are developing a system for a manufacturing operation. The planned approach is to develop stand alone data capture applications using MSDE for the database. The production data from these systems needs to be posted to a central SQL database. All systems will be in the same building. We p...more >>

I have got the issues as described in this KB article: http://support.microsoft.com/default.aspx?scid=kb;en-us;811008 What I should have asked is has anyone done fix # 2 to fix this? Any problems? TIA, ChrisR ...more >>

I have got the issues as described in this KB article: http://support.microsoft.com/default.aspx?scid=kb;en-us;811008 Has anyone found a better workaround for SQL2K than the one described? TIA, ChrisR ...more >>

Pls help with my issue. I have a table that was an article in a publication. However the publication to which the article belongs had been dropped but I stoll get the following error message when I try to truncate the table. What is goin on ? "Cannot truncate table 'tblContributorRole' beca...more >>

I have configured transactional replication between two sql servers 2000 by wizard, i have one publisher and one subscriber (distributor is on same server as publisher) I need to script all part of replication but for installing later and when i try it it's not successed. Can somebody provi...more >>

I've worked with SQL Server since 1996, bit I'm just now having to venture into the replication arena. Here's my situation... I have a database at our corporate office - about 1.5 GB in size spread across 100 tables and 450 stored procedures. The largest table right now has about 600,000 ...more >>

I'm new to replication, but I'm afraid we have a requirement that's not possible... We have a distributed app that must run on solely on MSDE (customer won't pay for SQL licenses), and (worse) the MSDE instances will NEVER be connected to each other (it may be hard to believe, but that's a ...more >>

Just about to begin work on an app that will likely need to use SQL 2K replication... Question: will we be able to use the replication "features" with only MSDE 2K installed (not a full SQL license)? Or does using replication require use of Ent Manager (or any other s/w not part of the MSDE...more >>

I´m developing an pocket pc application, I need replicate using two publications. My main form has two button, first button to obtain data from a publication and the second button to obtain data from the other. I delete my local PDA DB, and I can only obtain data from one of the publica...more >>

Hi, I have ran out of indentity range and I have a new PC to add. Is there anyway I can adjust the identity range and get to provide some identity range to the new PC? Thanks Vivek ...more >>

hello, there are many "dead" agents (snapshot, protocoll,distribution) in my enterprise manager of deleted replications .... how can i delete these agents as well? thx for help Alex ...more >>

I want to replicate between an SQL2k database and an Access database. Unfortunately, the field structures are not identical and neither one can be changed. How best to handle this scenario? ...more >>

Is there any way to find out a subscriber's assigned identity range (at the publisher)? It would be helpful to have an idea where a row was added from its identity value. ...more >>

In Hilary's replication book there is mention of a second volume on merge replication. Is this available yet? Is there a target date for publication? Thanks, Bob Castleman DBA Poseur ...more >>

I have two SQL Server 2000 servers using Transactional Replication with Push subscription. Once it was set up, the distribution agent kept displaying "the process is running and is waiting for a response from one of backend connections" while the subscriber's transaction log file kept growin...more >>

Is it possible to start replication (merge) using all tables and then later restrict the tables that will be replicated? Thanks. David ...more >>

I have an odd problem where one of my SQL servers merge publication is not passing the updates it recieves to the subscribers. The server in question also subscribes to a main server and republishes the tables from the main server to the clients in its location. I run the snapshot for th...more >>

I have set up merge replication between two databases and I consistently fail to get any records updated in one of the tables. Basically I have a one way push subscription from server A to Server B. Every table gets replicated except for one which never copies any records. I can't see anything a...more >>

I got transactional replication between two servers , two identical database (one publusher and one subscriber, distributor is on publisher server), everything works clear however a few days ago i got on Replication Monitor --> Publishers --> MyServerName failed icon snapshot agent, now on pa...more >>

Our company is being restructured. There will be a handful of separate sites , each using applications that access a SQL Server 2000 database. Our connections between the sites are expected to be fast and reliable. What we are looking for is a solution where we would have almost instantaneo...more >>

The disks are on same server. The server is a subscriber. I have a 9GB database that is replicated (Merge), and I need to move it from disk 1 to disk 2. I am unsure about how to correctly do this, I really dont want to damage the replication and have to rebuild the database as the connectio...more >>

Hi What is the best way I can monitor the total delivery latency for non-updatabale pull transactional replication in Microsoft SQL Server 2000 SP3? I've seem to have solved this by making a stored procedure that executes in background and every second updates an user settable performance c...more >>

Hi, maybe someone have suffered this before. I'm able to make in the server a publication (W2K ADV. with SQL Server 2000 Standar and SP2). I can't upgrade the SP4 now. Then I'm trying to make in my computer a suscription (WXP with SQL Server developer and SP4) . The error is the "14053...more >>

Salve, On my way to learning this SQL stuff I've come a cross a problem I'd like to resolve. I hope this is the right place. I'd like to be able to Start/Stop the Snapshot Agent through C# code. Is there any sample code available on this or can someone point me to where I might be able ...more >>

I'm getting a error 28035 "Header information is either corrupted or missing." when I try to synch a SQL Mobile 2005 database with a SQL 2000 publication. I'm not getting anything in the log file on the server. I'm running SQL 2000 sp4 and the SQL Server Agent for SP4 on a Windows XP Profes...more >>

Hi all, I'm trying to use the SqlCeReplication object to add multiple subscriptions to the database (.sdf). But when I try to add the 2nd one, I get an exception with the message "The SQL Server CE database is already enabled for replication." Does that mean for each SQL CE database, ther...more >>

I have several systems located aroung the globe that currently have Merge Replication running just fine. I've recently found that if I add an index to one of the tables, my application will perform much better. How does adding indices on tables effect the Merge Replication? Is this consid...more >>

I have successfully configured log shipping, and verified that the standby server is being updated correctly. There is one job named "Log Shipping Alert Job - Backup" which fails every minute. In the job history, it says: 'The job shipping source SERVERNAME.DATABASE has not backed up fo...more >>

Hi, I'm getting this error on trying to setup a push Merge subscription. The Merge Process could not initialize the subscription {call sp_MSmergesubscribedb *;true') } Invalid column name 'maxversion_at_cleanup' Invalid column name 'published_in_tran_pub' The system tables for the merge re...more >>

Hello, What happens when you have sub that expired (14-days), you try to sync & it says please reinit, however; went to the pub & just increased the exp time to 45 days, & its able to sync... what is the data ramifications of doing this?? Thanks!! -- Scott Kramer CDS Technologies, ...more >>

We have a head office database and few branch office database. We are going to connect the head office database with the branches through replication. Both head office and branch database have data in them which needs to be replicated (Merge replication). How do I replicate data alone ...more >>

Hi All, Publisher/Distributer : SQL 2000 Subscriber : SQL 2000 I have set up a Merge Replication issue across internet via VPN. When I connecting a DialUp modem(56 K), I get errors in the replication : Error Message : The process could not deliver insert(s) at the 'Subscriber'. Error de...more >>

I have a setup where a single 1.5 million row table is published to 6 separate databases using merge replication. On 4 out of the 6 I have no problem, but on 2 there seems to be an excessive performance hit on the subscribing server's CPU when the distributor attempts to apply updates AND th...more >>

hello, I have a SQL2000 server with circa 20 databases. I am setting up Log Shipping for these DBs. These DBs are not very active so I want to replicate every 2 hours. I can schedule all three steps separately: - backing up the log on the source server - copying the log-backup from the sour...more >>

Hi All, After SP4 I cannot run merge replication. Snapshot agent try 10 times to start and on the end give me a message 'No such interface supported. blalblabla'. Do You have suggestion ? Regards, Tomasz Skorupa ...more >>

Usually I use Enterprise Manager to remove the Merge Replication info before trying to drop a database. Now I used sp_dropmergepublication and successfully dropped the merge publications associated with a database. When I try to do a DROP DATABASE though, I receive : Server: Msg 372...more >>

Hi, We have 4 different international sites that will need to replicate changes between 4 tables. Each site will need to make changes to the tables locally and have those changes propogated out to the other 3 sites. Data volume will be about 25 changes per site per minute. Latency should...more >>

I have a system where I utilize merge replication between sqlserver2000 and pocketpc sqlservece 2.0. The setup is very mature, and has been working fine until I had my customer "refresh" the database with new data. We're still in the testing phase, and the database I connect to is a copy of their...more >>

I am trying to setup transactional replication from Source db to targe db in our dev environment. Because of some network constarints i am planning to to replicate some tables continuously to subscriber and some tables every 3 hrs and some every 6 hrs. To achieve this- I have created 3 ...more >>

I am having a problem with merge replication at one installation site. They have SQL Server 2000 on the server and 2 laptops. When the subscribing laptops synchronize the changes from the subscriber are uploaded to the publisher but no changes from the publisher are downloaded to the subscri...more >>

This may be a basic question, if so, apologies in advance. We're having to set up a new subscriber for several publications. From what we remember, the last time we added a subscriber, running the snapshot agent caused every subscriber (not just the new one) to get a brand new copy of the tab...more >>

I have ServerA and ServerB. I configured ServerB as distributor and allowed ServerA as a publisher for it. Then I started to configure ServerAs publisher using ServerB as distributor but the process failed with error stating SeverA0 is not enabled as publisher for distributor ServerB ... event...more >>

Hi everybody, are there any recommendations concerning the bandwidth given I want to replicate a 4 GByte database? We're using a 256k line (not exclusively) and the replication is breaking down every time. Any suggestion appriciated Thanks Peter...more >>

Hello, I have a merge replication setup between two sql 2000 servers. It works fine, but there is some data in one table that I wish to hide - at the subscriber database. This data is in 4 columns in one table. It would be best if I could exclude the table altogether from the replication ...more >>

Hi, Can a subscriber (in merge replication) filter the rows and send the changes only for particular records to publisher? Thanks in advance, Leila ...more >>

Hi all, I have an application that creates a publication on the server, and have multiple mobile devices creating annonymous subscriptions to that publication. I need to write a report that checks if each device have the replication synchronized successfully. I can run distribution.dbo...more >>

Hi all, I'm doing merge replication sql2000 to sql2000, handled programatically in my c# application. Everything is working perfectly when the publisher and subscriber are on the same SQL Server registration, but not when I try to replicate with SQL Server on our server. The Server DB re...more >>

I am new sql server and have a vendor application that we need to stop replication to make updates to the application, the restart replication after the updates are complete. I am running sqlserver 2000. Is there an easier way then to delete and redefine the publisher. Thanks, Webb...more >>

Hello; I am working through the SQL Server 2000 System Administration (Self-Paced Training Kit Exam 70-228). I am trying to create a publication using the Create Publication Wizard. When I get to the screen where it asks for Publication Name and Publication Description there is a check bo...more >>

I was hoping someone could help with a Transactional Replication error that I continue to receive.I have set up a total of 4 articles and am only receiving the error on one of them. I am running SQL Server 2000 SP3 and have the distrubitor and subscriber on the same box. I go through the norma...more >>

Hi, Couple of users got this error after installing (MSDE) SP3. Does anybody know what this means and what to do? Invalid column name 'published_in_tran_pub'. (Source: xxxxxxxxxxxxx (Data source); Error number: 207) ---------------------------------------------------------------------------...more >>

Dear Sir/Madam, Hello, I have two Server, same as hardware configuration and both of are domain controller, I have installed SQL Server 2000 Standard Edition on both of them. I want to replicate a Database on one of these servers as one way replication to other server. I only want that all...more >>

Hi , I want to monitor merge replication, So I am using these options in merge agent -Output C:\Temp\OUTPUTFILE.txt -Outputverboselevel 0 But I am getiing just the error heading not the details as available from the sql server enterprise manager. Can anyone tell me how to generate detailed...more >>

Does anyone know if a 2005 server can replicate data with a 2000 server or do they all have to be 2005. Thanks in advance Martin ...more >>