is it possible to stop replication in cmd prompt for MSSQL2005? Thanks in advance!...more >>

Hi all, I am trying to create a merge-publication (SQL 2000 SP4). Unfortunately, it is not working because the wizard pops up with error 14258: Cannot perform this operation while SQL Server Agent is starting. Try again later. Checked both services, they seem correct. Both are using (the...more >>

Is it possible to setup a merge replication chain where you have a Head Office (HO) which is a publisher to a Region Office (RO) subscriber which is a publisher to a Store Office (SO) subscriber where the data travels both directions fully? eg. HO<->RO<->SO. From testing, it appears that i...more >>

Here's something I've never run into before, and I hope someone can help. I have two identical SQL2000 databases (DB1 and DB2). Each has a different name and is part of a different merge scheme. My developer has an application that writes data from a table in DB1 to an identical table in ...more >>

I know that if you're doing log shipping and someone runs a fast bcp ( non logged ) activity against the database that subsequent transaction log dumps won't load until you do another full dump and load. This can be a problem, because of the time involved in dumping and loading. How does tran...more >>

Recently we upgraded to a new sql server. My plan for upgrading was to backup the database on sql server 2000, restore the database on 2005, create new publications, and then have the ce databases reinitialize with upload changes set to true. This worked for me in testing. Now that we've ch...more >>

We are trying to create generic scripts to enable/configure replication at various customer sites that purchase our product. As I have no way of knowing which drive they will use for data and log file storage I would like to set the @working_directory parameter for sp_adddistpublisher to null...more >>

Hi, I create a Merge replication with Sql Server 2000 on a server Windows 2000 Server I use a Remote Distributor also on Windows 2000 server. All the salesman use a Laptop with Windows XP and MSDE database I Create a pull subscription with all the articles I need Now if I have 5 laptop ...more >>

Hi all, I have a publishing database and a subscriber database on two different machines. Transactional replication is configured between them. Everything is straigforward at the start, then after a few days I got reports that the same tables on both databases are not in synch, and some tab...more >>

Hi, I have 5 offices accross the US. At the HQ we have a legacy system (unix) with customer data. I want the customer data to be replicated to the offices SQL servers (MSDE) automatically. The legacy system does not support replication so I was thinking of running a DTS task nightly to copy t...more >>

The application error log on my SQL Server 2005 is full of error messages from my push subscriptions not being able to connect when they are off the network. I have a SQL Server 2005 publisher to several MSDE merge push subscribers. Many subscribers are laptops which go off the network for ...more >>

Win2003srv mssql2000 mssql2005 Oracle I have a mssql2000 database that I Replicate to oracle, some tables have row filtering. This was working fine until I create an another publication and subscription (transaction) on the same database, for mssql2005 This subscription has the loopback...more >>

I have transaction retention period set to default 72hrs on distribution agent. I would like to increase it from 72 hrs to 336 hrs. Will this change comes into effect immediately..??? Will this increase in retention period applies to transactions that are already in distributoion but not ...more >>

We’re using transactional replication to create two databases, one for transactional data, and one for reporting data. In the transactional database we will allow data purging via a stored proc. We will not replicate the deletes caused by the purge stored proc to the reporting database. T...more >>

I develop downloadable (shrink-wrap) software currently used by individuals. My users are typically running MSDE/SQL Express on their own computer for their personal database. But now small groups of people here and there want to move past having their own personal database and they want to s...more >>

Hello, I installed replication on 2 computers. Both running MS WIndows XP with MSDE 2000 SP3a. My mistake was to leave the retention period to be 14 days. The user unfortunately leave it for more than 1 month until trying to synchronize. Now since the subscription has expired and no meta da...more >>

Suppose I delete a record in a database at 12pm. And one staff modified the same record in another database at 1 pm. Aftere the merge replication, does that record still in both databases or not. ...more >>

When Attempting to set up replication on my SQL server 2005 server, I right click and select new publication and imediately get the following error message: SQL Server is unable to connect to server 'spi-svr6'. (New Publication Wizard) ------------------------------ For help, click: htt...more >>

I'm migrating from sql server 2000 and iis on one machine to sql server 2005 on one machine and iis on another. My clients are sql ce 2.0 and I'm getting the error message "Process could not deliver the snapshot to the subscriber" when I try to sync. I've checked the permissions multiple tim...more >>

Hi Guys, I would like to find out, on average, how much data is synchronized over a period of time. Is there a log or some other way for me to find that? Thank you, Maer ...more >>

I'm trying to come up with a strategy for handling design changes with merge replication. By design changes, I mean adding/dropping columns, adding/dropping tables, and sometimes doing some updates to the data. Let me give you some background on how I'm currently managing design changes (n...more >>

Hi, I'm Roby Eisenbraun Martins, I'm a C++, VB, C# and ASP .NET developer. I would like to know if is possible to identify if a subscription is being synchronized from the subscriber's database, without accessing the publisher's database. Thank you, Roby Eisenbraun Mar...more >>

I have set up a replication between mssql2000 to mssql2005 Mssql2000 is the publisher and mssql is subscriber. And it work fine. Then I remove the publication because I need to do spm Alter statement against Tables in the database When I try to add subscription with @sync_type = N'none' ...more >>

Help! I have a hierarchical CentralPublisher >>> Publishing Subscriber >>>>Subscriber topology that is not playing the game. There are no Conflicts or any error messages or deletes occurring as a result of replication. The problem i have is that changes made at the central publisher are n...more >>

I am wondering why the default for merge changes has chanegs to row-level tracking (from a default of column level tracking in SQL 2000). Is there a disadvantage to column level tracking in 2K5? Also, when I create new table relationships I always set them to Not For Repplication. I was s...more >>

I just started to use SQL Server replication. When I configue the Publisher and Distributor (they are on same server), the snapshot folder is always invalid. I was using administrator ID, the folder is located on the local machine, it's shared. What else I need to change? Please help. Thanks....more >>

Is there such a thing as a "Replication BLOB Trigger?" -- Enover...more >>

Hello, We have an application to do some replication between SQL Server 2000 and MSDE. After a good install of MSDE, we have this error : "20084 The process could not connect to Subscriber" when we try to synchronyse data. So, the replication is OK on another PC (they don't have the sam...more >>

Is there any requirement for either the publisher or subscriber to have full recovery model enabled when using transaction replication. ...more >>

I'm can't get my SQL2000 to push data to SQL2005 Express neither I can get my SQL2005 to pull published data. Any idea, is this actually possible with current version? Any help will be appreciated. Milan. ...more >>

Hi , Previously , i have set up replication to replication Table A , B & C . However , now that i need to replicate tables D , E & F , can i simply go to the properties of for that replication and add in the new tables under articles ? Will this cause a new snapshot to be created and t...more >>

Win2003srv: I have set up replication between mssql2005 and ORACLE 10g The subscription is working, but the scandinavian characters (æøå ÆØÅ) is damaged at the Oracle database. The scandinavian characters is NOT damaged when the initial snapshot bulk copy, but when transactional replicatio...more >>

Hi all I'm wondering why the status information is not 4256 rows merged (4256 inserted, 0 updated, 0 deleted , 0 conflict)? I think rows merged must = rows inserted+row updated+row deleted. But most of the report of Last Action in Merge Replication Monitor do not show that. I saw rows me...more >>

I am new here and trying to make SQL Server 2005merge replication example SalesOrders work. I made https work on Windows 2003 web server. However when I tried to WebSync I got an error. The message is attached. Would somebody tell me how to add an http header Content-Type to the WebSync proce...more >>

I am trying to maintain replication from an app I have written. Occasionally, a subscription will have a problem and error out. When the subscription is restarted, it often will not start resynching until if feels like it. What I am looking to do is check the status of all subscriptions a...more >>

Environment: SQL 2000 SP4 on Windows 2003 Replication Type = Transactional Replication Servers involved = server 1, server 2 Activity = server 1 has lots of activity for inserts,updates but no deletes for 7:30 AM - 6 PM NY TIME then it becomes stable and becomes active again from 9 PM - 4 AM...more >>

Hello everybody, I have been asked to configure a transactional replication of the main database being used by an installation of Siebel 7.5, currently running on SQL Server 2000. Unfortunately, I have discovered that Siebel doesn't use any primary keys in its tables and enforces referential ...more >>

Hello.... Are the only parameters allowed for dynamic filtering of data just the Host_Name and SUser_SName? Just curious... thanks - will...more >>

Hi, We are running continuous merge replication on about 50 databases (sql server 2000). Each database has only one subscriber, and that subscriber is located across the internet and available via a VPN tunnel. Since the publisher server is our "live" server, I set up the distributor on ...more >>

Hi All: I already have a Merged Replication setup between Site A and Site B, for all the articles in DB at Site A. Site A is a Publisher and Site B is a Subcsriber and its an anonymous Pull Subcription. Now I want to set up another Merger Replication between Site A and Site C for only 3 artic...more >>

Here is the context, in short. I have 2 remote sites with SQL Server 2005. Each server can't see the other one. I need to replicate data between them. I use MSSQL Management Studio with SQL Server Developer Edition. When creating a publication, I can say that I want the snapshot to be put on...more >>