I am trying to send it again as I had no response. I would like to start transactional replication in continuous mode but the only thing I dont want is having the distribution agents started . I would like to start the distrib agent jobs manually after we check a few processes ...more >>

I'm building a distributed sales system with a central database and about 50 not-always-connected sites. The schema is something like this: Customer Id uniqueidentifier (PK) Name varchar Invoice Site int Id uniqueidentifier (PK) CustomerId uniqueidentifier Total m...more >>

I keep getting an error 511 when I try to publish a table. It says that the row size exceeds the maximum row size of 8060 bytes. I hear that splitting up the table is one way, but this table is an integral fixture across many apps in our system (we've been using it for years), so redesigning i...more >>

I have a Sales Person running Merge Replication that is suddenly get conflicts when synchronizing. Some of the conflicts give the message "String or binary data would be truncated. A similar thing happened a year ago and one field was too small in a table when a audit trigger fired. I captured...more >>

Hi all. Im trying to set up replication from Enterprise Manager to one of my databases. I have successfly done it for the Northwind database in this server but now I get this error when trying to do it for another database. The complete error message I get when I click on the Finish button of ...more >>

Hi! We are attempting to replicate a SQL 2k (Win 2k) server with another server of a very similar spec but the whole process has been a disaster... Firstly merge replication pushing the subsricption seems to constantly have a status of "deactivated"! If we use pull subscription, the sub...more >>

I have a table that is part a merge publication that I need to delete 3 million rows from which will leave about a million in the table. I plan to just insert a list of the id's to go in a temporary table and then just do delete where id in table X. Another way that has been suggested to...more >>

My Log Shipping process has been up and running fine for about 6 months now. Then as part of the preparation for upgrading the front end application for the log shipped database, my partner DBA thought he would help the backup speed by running a SHRINKFILE over the database files. It was o...more >>

I am using merge replication and trying to configure an alternate synchronisation partner (ASP). My topology is V-shape and replication is working OK as long as I do not perform a sync of the subscriber with the ASP. My subscription contains articles having identity columns managed by merge ...more >>

Hello, I have 600 gig of data on my disks on windows 2000 server with SQL Server 7.0. I am using robocopy for fast data transfer between 2000 and 2003 disks. but my application team wants to set up replication for exact data sync, i mean after files with robocopy, i want to set up replicat...more >>

After working for over a year, one of our snapshot replication distributions now fails with the following error: The process could not bulk copy into table '"texttab"'. Expected the text length in data stream for bulk copy of text, ntext, or image data. (Source: DESTINATION_SERVER (Data sou...more >>

Hello, I have to do a task, but I'm newbie in sql server replication, so I ask you what I have to do in this case: I have two SQL Servers A and B. What I have to do, is to synchronise some tables from these databases. So when I modify a table in srvA, to update in srvB and vice-versa wh...more >>

Hi, the idea is to setup an offsite backup of our single sql server, have created a publication on the MASTER server, and pulled it to the offsite server using FTP, downloaded snapshot, replicated transactions, all appeared to work, generated schema, but the frontend database app didnt run,...more >>

I have two databases say A and B on the same server. A is updated through an Access front end. A is set up to transactionally replicate some of its tables to B. The Log Reader does its job - confirmed by running sp_browsereplcmds to see the content of MSrepl_commands. However the Distributio...more >>

Hi, I have one publisher and two subscribers, i want to filter the data dynamiclly before sending it to the subscriber(s), my question is, how to know the current subscriber when the merge agent implement the filtering criteria, i tried to use Host_Name() function to know the current subscr...more >>

Hi, has anyone of you experience in replicating Commerce Server 2002 DBs between two sites? Both sites' web servers are accessible from the internet. Placing orders should also be possible on both sites. Is there any recommendation / experience which replication model (mix) is to be used i...more >>

I'm considering a solution to retrieve user selections from another source and automatically use them to set my SQL replication filter criteria. The filter includes at least one table join. Is it possible to set replication filter criteria programmatically? ...more >>

Hi, I am setting up a disaster recovery server and I need to configure it so that databases on the main server get copied every few days. I thought of doing an export with DTS and then saving the package and set it to run on the specified dates, but the problem is I would have to remember t...more >>

Hi, We have two DataBases Residing on two different Servers. We would like to set up real time uodates between these two servers. We have an Inventory System on server A and a Tracking System on Server B. Now an Transaction in Server B should Update a Certain Table or Tables on Server A. and ...more >>

I have set-up Transactional replication with a pull subscription, for a database that we are playing with at the moment. Had a few issues getting it running, but now it is doing the job. The only problem I have is that the database on the publisher, has Primary Keys specified, but when the d...more >>

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