Hi Is it possible to reliably sync an access db with its equivalent sql server db using the built-in facilities of sql server and access? Thanks Regards ...more >>

We're in the process of setting up a high availability system in two separate geographic locations using SQL Server 2000. One will be used as primary production site, the other replicated to be used in two ways: 1) hot backup site in the event 1st site is unavailable, and 2) for purposes of acti...more >>

Is it possible make a normal replication with an isa-server published port of the sql server - without using VPN or web-publishing?...more >>

We couldn't get Merge Replication to work at a reasonable performance, and we now think log shipping is the right tradeoff of reliability and performance for this project. We're inexperienced, though, and would like to have a replication expert review our plans and support the implementation. ...more >>

I have a desktop XP Professional, and a Laptop using XP Professional. I have a SQL database I want to Merge Replacate to-from. Can it be done? Or do you have to have SQL Server 2000/2003? The reason I'm asking is that I try to setup replication, and it keeps failing because of Access Rig...more >>

We have a web application which has a tablet component. The web application replicates data to the local SQL Server 2005 Express database and a local Dot.Net application connects to this database. In disconnected mode, we need to run reports. I know we can use the Dot.Net report viewer control...more >>

First of all thank you very much to Mr. Paul & Hilary for unlimited help & guidance. as my question is about adding new fields (sp_repladdcolumn) & i have all information with your help. my question are:- 1> as i have TWO publisher for same DATABASE for e.g. Databse ABC = Publisher PUB1 & ...more >>

The error message is: Message 2006-05-19 17:52:59.356 The system cannot find the file specified. 2006-05-19 17:52:59.356 Category:NULL Source: Merge Process Number: -2147221502 Message: The system cannot find the file specified. 2006-05-19 17:52:59.356 Category:NULL Source: Merge Proc...more >>

At the end of the configuration of the wizard for a transactional replication between two SQL 2000 SP3+, i get the following error : Error 0: This Server has been disconnected. You must reconnect to perform this operation I didnt find any clues in tte sql log or the events log. Neither in ...more >>

Hi, I want to know if they can help me to solve the following problem. I have a database duplicated by merge replication, and want to control conflicts that are not seen as conflicts by the replication, but they are conflicts with the logic of business. I explain: I have a PDA with the r...more >>

Hello - I need to set up Transactional replication between two SQL 2005 servers. The servers are in different domains (they belong to different companies), but a VPN connection has been established. I can see both servers from my SQL Mgmt Studio and each server can "see" the other one. ...more >>

Hello - We are running SQL 2005 and I am wondering how we can allow our subscribers to continue to sync/replicate if our production/main server fails and rolls over to the backup server. Is this all handled via DNS or some other mechanism? Right now, we have subscribers (smart devices) wi...more >>

Hi Everybody, I have encountered a problem when I was creating the transactional replication. My design was putting the distributor and subscription on the same machine. I was able to create the distributor however when I tried to create Publisher from publication machine it asks me to define ...more >>

Hi , I have setup Replication alert to send email to me while the agent failed or retry from the Replication Monitor i can see my replication is either retrying or fail but it did not seem to trigger the Replication Alert as the count is still showing 0 is there any way to check why it was...more >>

Hi, first, excuse my poor English. I am new in the world of SQL Server and have a doubt of applying filters to data to synchronize. I have an application in a PDA, and the database in SQL Server 2005, and I want to filter the rows by several criteria, for example, orders introduced by cer...more >>

I'm having problems with this object. The first time I ran dependency walker on it, it said msjava.dll wasn't there. I added that. However, I also get an error in mpr.dll that says: WNetRestoreConnectionA Warning: At least one module has an unresolved import due to a missing export function i...more >>

I have a production SQL 2000 server where I've implemented Merge replication in a transaction-heavy environment. I'd like to create a datamart on a different 'reporting' SQL 2000 server and use Transaction Replication to migrate changes from the transaction/production server over to the repor...more >>

I think I'm getting old and can't remember how to do this, but can anyone remind me how to set the retention of these snapshot histories in my repldata directory. I keep running out of disk space and having to manually delete these folders is cramping my style. Any help would be appreciated....more >>

Hi All, Does anyone have any links that detail what sql tables/fields are used in replication, and ideally what they do. There have been a few times now where things have broken and I've wanted to dig into the tables and see where it's gone wrong, but haven't known how they tie together. Th...more >>

Hi, I hope soeone can help I have a SQL2000 publisher/disstributor, and two SQLServer 2005 SP1 subscribers (mirrored using SQL2005 DB mirroring). I'd prefer to utilise the SQL Native CLient OLEDB (less overhead) as the driver to the SQL2005 machines. However, though I can initialise the s...more >>

Hi, Just wondering what the benefit is of using replication over linked tables is in a network solution (no offline sync is required) Sorry, if this is a bit of a silly question, but I don't really know what the answer is. Thanks. -- Regards, Alan...more >>

Hi, While I setup transactional replication on SQL Server 2005, it recommend to using proxy account to push data. What's the proxy account permission (for instance: local admin domain, password never expire, etc) should SA create for it? Regards! Chen ...more >>

Hi all, Just a quick question about the new Replication Monitor in SQL 2005. Is there any type of configuration setting where, if I have it iconed in taskbar, that it will automaticaly pop up if & when one of the publishers has an error? Thanks, Billy ...more >>

Here is the situation(hypothetically) I have an VB application which is built on a Access 97 database using DAO (and not ADO). I want to create an equivalent(subset) VB .NET application for mobile devices,so that in a sense both the PDA and the desktop application acces the same data. I know...more >>

We have several production servers that are 2000 sp3 and use transactional replication. We need to apply sp4 to the distributors for the AWE fix (including the hotfix). The question is do we need to apply sp4 & hot fixes to the subscribers at the same time or can it be applied to them as tim...more >>

Hi All, I would like to set up transactional replication with failover cluster. Did anybody tried this? Does it work together? Is there anything I should be coutios when I set up these together? or Is there any glitches? If somebody helps me I will really appreciate it Thanks ...more >>

Hi all I am having issues to replicate through HTTPS. I get the following errors when replicating. "The subscription to publication has expired or does not exist" It is from an XP Machine running SQL Express 2005 to a 64Bit Win 2003 with SQL Server Enterprise 2005. Does anybody have an...more >>

Hi, We have an application that collects and analyse datas from a measure robot. The datas are stored in an SQLExpress2005 database. This database is merge replicating through a pull subscription using a SSL Web server that acts as Publisher and distributor. The replication works fine (with...more >>

Hi, May I know whtat difference between the job of 'Distribution Cleanup' & 'Agent History Cleanup'? When I configure the transactional replication, system set default schedule every 10 mins to execute both jobs. However, both processes cause system performance drop down and deadlock occurs...more >>

Can anyone point me to any resources that might inform me as to how I might go about replicating data from a DB2 database that's housed on an iSeries machine to a SQL 2005 instance? I'm hoping that I might find a solution that wouldn't require Host Integration Server as I'd like to avoid the a...more >>

Distributor w/ 2 subscribers. Subscriber A works fine, subscriber B has 100% CPU usage while the subscription is being replicated. If I click Stop Synchronizing, the subscriber goes to 1% CPU. Start Synchronizing shoots to 100%. I know it is SQL causing the 100% because the Task Manager says s...more >>

Hi, I have a transactional replication set up with a publisher, remote distributor and three read-only subscribers. We're running W2K3 on all and SQLServer 2000 SP3. Replication has been running fine for more than two years. Recently, when creating a new publication and adding a new table ...more >>

Here is a snenario, that I have tested and would like to know what are the some the possible issues? I took my Transactional replication publisher database out of replication by updating the column category from 1 to 0 in teh sysdatabase tables. I did stop the Agents before doing this. Then...more >>