Recent update: 2008-3-21
I had a merge subscription expire and now need to synchronize two disparate databases. How do I do so without overwriting the subscriber database with the publication snapshot? Thanks for any help you can give.
721 byte By
VDeevi at 2008-3-6
Hi,We are using VSTO 2005 and developing an Ms-Office Excel application which has to work both in Online and Offline. When the user connects to office LAN network then the data that the user will use data comming from our centralised database. This is for online scenario but when the user is in ...
Hi all, When we right click a replication agent, we can see error details tab. But in some cases the tab is disabled and in some cases it is enabled.I'm curious to know under what circumstances it is disabled and under what circumstances it is enabled. Thanks in advance, Preeths.
Hi all, We have 2 merge replication jobs. I want to complete one job and then start another job after the first one is completed. Is there any way, that I can make the first job to trigger the second job as soon as it is over? Thanks in advance. Thanks, Preeth.
685 byte By
SeanDL at 2008-3-1
Hi thereThis is a pretty straight forward question.When using sp_droparticle or sp_changepublication etc, basically any replication system stored procedure.There are many parameters for these sp's basically all i want to know is if i provide the relavant paramaters,that is publication name, ...
1830 byte By
SeanDL at 2008-2-28
Hi ThereMy problem is that a while ago i posted a question here reagrding changing remote distributors without having to reinitialize subscriptions becasuse alot of data was involved and creating and applying the snapshot would require too much downtime.The solution provided (briefly) involved ...
Hi guys,When I do the RDA process, this weird problem comes out. I don't think there is any problem with the connction between the SQLce Server Agent and SQL Server agent.Everytime I run the RDA process, it looks like it is waiting for the time out of the connection. And If I cancel this ...
679 byte By
momak at 2008-2-26
This is very important.I have merge replication with publisher and distributor on the same server and about 20 Subscribers all over the country.We are moving to another building, with new equipment, so Publisher will be on different server. How to make this move easily, without recreating new ...
1243 byte By
St3veM at 2008-2-25
Hi All, I need to get some assistance with some replication deadlocks im getting. We have two servers, which push information between each other, which I have a hunch could be a cause.Basically I keep getting the 'Agent Retry' Alert from SQL: DESCRIPTION: Error: 14152, Severity: 10, State: 1 ...
613 byte By
Krithi at 2008-2-24
Using our ASP.net application we are getting inconsistent results when we are trying to update a table with more than 15 update queries sequentially. We are using Merge replication in our SQL server database. On updating one row, it invokes a trigger to update another table and one more trigger ...
1223 byte By
DavidG at 2008-2-23
I'm trying (and failing!) to get Web synchronization for merge replication working with SQL Server Standard 2005 Sept CTP. I've created and configured a merge publication and have configured the publication for Web synchronization using the 'Configure Web Syncrhonization' wizard. I've ...
We have a publisher and 2 subsribers. The subscribers are spanning 2 transactions/sec. We have inplemented merge replication and it was scheduled to occur every 5 min. When we start the replication, the replications is going on without any problem for sometime(may be some hours), but after ...
Those of you who have installed SQL Server 2005 may have noticed that the installation creates several new Windows groups on the server. Do not underestimate the importance of these groups.I had been unable to configure Transactional Replication. Everything worked fine until I tried to start ...
Hi,I am getting the following error when i setup a pull subscription on SQL Sever 2005 RC1. The Snapshot agent and Logreader agent are running fine but when the distribution agent runs to synchronise the subscription fro the first time, the following error occur. Its something i haven't seen ...
- Synchronizing Data (100%) (Error) Messages Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the SQL user is not a valid user on the SQL Server, or the password is incorrect.HRESULT 0x80004005 (29060) The operation ...
Will this work with replication too. I see it with a mirror database, but could it work if I was keeping two copies of the database and wanted to transparently reroute the connection to a surviving server?
Hi all, Can Enterprise Manager remove a table from replicating to another server? I've tried looking at the article tab of the property of the publication but couldn't find a way to delete a table from the article. Any idea? Thanks!
How could I create an allocation or consistency error (or otherwise corrupt a db) in a database to test a backup and restore system?
Error returned when trying to commit the transaction to a database that is a replication distributor. (sql2005 ctp16)the error I am seeing: Msg 627, Level 16, State 0, Procedure sp_MSmerge_altertable, Line 305 Cannot use SAVE TRANSACTION within a distributed transaction.Anyone encounter ...
246 byte By
TMF at 2008-2-17
on the same machine both 2000 and 2005. 2000 replicate to 2005, then 2005 replicate to 2000. I recieve the above error from 2005 instance. The replicates (both) work fine, but the application EVL is full with this error. Any Ideas?
301 byte By
TRB at 2008-2-16
I added couple of new columns to the distribution database and those new columns are not being replicated. I have executed sp_articlecolumn to add these new columns to the article. Still it doesnt work.Any help is ...
Hi, i need to make a synchronization between a sql server 2005 express and mobile database. Sql server express cannot act as publisher for merge replication. Could anyone tell if it is possible to use the RDA replication between the express and mobile databases? Thanks in advance, Nuno Silva. ...
In order to deploy the replication implementation along with the software that has been created,how to package the correct set of necessary assemblies along with our client to ensure that the software can function correctly? While trying to include the SQL Server assemblies that we are using ...
Hi, i need to make a synchronization between a sql server 2005 express and sql server 2005 mobile. I think this is not possible using merge replication and RDA. Was this right? If so could anyone help and present a possible workaround for my problem? Thanks in advance, Nuno Silva. ...
I am building RDA process between SQL server and SQL server CE. Since when we use the method 'SqlCeRemoteDataAccess.pull()', the data will be pulled down from SQL server to CE server and a new table is created with some addtional columns. As I only intend to pull the data and never push it ...
991 byte By
R_oo_T at 2008-2-15
Hi,I am a SQL server admin fo my company and I have the following situation:My company has several sales offices in cities across Europe. Each office stores its own inforamtion about orders and billing in a SQL server dtabase. Central headquarters in AMtserdam stores all the info from the other ...
899 byte By
Malik at 2008-2-15
Hi Guys, i m very new to replication on sql server 2005, i have configured a merge replication between two servers and it's working fine, but when i try to add another server under the same publication or add new publication and add subscriber i m getting following error. Can any one tells me ho...
Hi guys,Correct me if I'm wrong. That's wat I was doing.. Try to perform a merge replication between the 2.But the following errors are wat I've got during the syncronization:Error Code: 80004005Message : RunMinor Err.: 28557Source : Microsoft SQL Server 2000 Windows CE EditionErr. Par. : ...
Hi,I have to move a SQL2K instance (publisher) to a SQL 2005 instance and i prefer not to re-snapshot all the databases being replicated due to the large size of the databases. As i understand all i need to do is 1. Ensure all published databases are in readonly mode.2. Stop the replication (by ...
838 byte By
J1102 at 2008-2-13
Hi all,Finally snapshot is generated.Then i create a pull subscription (i am using merge replication). But after executing 193 actions it gives following errorLine 1: Incorrect syntax near 'No_'Details are as follow.1. The subscription has been marked for reinitialization. Reinitialization ...
4094 byte By
pdns at 2008-2-13
Hi,Iam trying to perform merge replication between SQL Server 2005 and SQL server mobile. It has previously been working. Recently something is causing the following problem when i try to perform the merge. I grabed the following output from the replication monitor.Error messages:An error ...
1088 byte By
SeanDL at 2008-2-12
Hi ThereI needed to change a column definition for a published table.I did the following.sp_dropsubscription for publication specifying the one article.sp_droparticle for the specific publication/artcileBOL is not very clear here, i presume this drops the subscription ONLY for the 1 article , ...
205 byte By
J1102 at 2008-2-11
Hi all, I have created a new publisher. There are 997 articles. Snapshot agent has added some of the articles and after that it failed with error Line38: Syntax error near 'tabl' Please help.
Hi,I have to move a SQL2K instance (publisher) to a SQL 2005 instance and i prefer not to re-snapshot all the databases being replicated due to the large size of the databases. As i understand all i need to do is 1. Ensure all published databases are in readonly mode.2. Stop the replication (by ...
Hello Everyone,I have a situation where I am creating a merge publication on 2 databases using a customers table. When I create the publication it adds a column to the customers table called ROWGUID as a uniqueidentifier column. This is perfectly understandable as the merge needs some way to ...
HiMy merge replication (over Web) has been working fine. But since two days, I've got the following error:If I'd like to reinitialize a subscriber or add a new subscriber, the following occures (on the client side):Client connects to the (Web) serverAll the snapshot files are loaded down to ...
Hi all , In my VB.NET application i have made a synchronization function which synchronize the data from a SQLCE SERVER 2000. till the data is less the synchronization happen well the data from the PDA database to the Desktop version database goes well but when we increase the data size in the ...
ISSUE: While synchronizing data between the PDA and MS SQL Server database, using Active Sync connection, the sync process fails at times and displays an empty error message box and occasionally it shows the following exception: Error During Synchronization: A native exception occurred. ...
1088 byte By
SeanDL at 2008-2-7
Hi ThereI needed to change a column definition for a published table.I did the following.sp_dropsubscription for publication specifying the one article.sp_droparticle for the specific publication/artcileBOL is not very clear here, i presume this drops the subscription ONLY for the 1 article , ...
Hi!I'd like to publish two publications, both of them have got the same articles. That is all working fine.But what when I'd like to make an article download only in the one publication and writeable in the other? If I change the status (downloadable only) in one publication, it's ...
691 byte By
june at 2008-2-7
hi,i'm using SQL Server CE 2.0 in my application.When i try to synchronize my database by callingreplicator.Synchronize();errors :Initializing SQL Server Reconciler has failed.process could not connect to DistributorSQL Server does not exists and access denied.what i did right now is i try to ...
466 byte By
SeanDL at 2008-2-6
Hi ThereAfter using snapshot replication from Server 1 to Server 2 i found that the primary key contraint was not transferred to server 2.I used the option to truncate tables for snapshot.The indexes are there as nonclustered unique but the primary key constraint for the tables no longer exists ...
793 byte By
SeanDL at 2008-2-6
Hi ThereI realize these question are not specifically for replication by anyway ....I am using snapshot replication from Server 1 to Server 2.I cannot use the drop table option for replication publication.The distribution agent keeps on failing if a colmn order is different or an index defined ...
531 byte By
Gravy at 2008-2-5
Here's a quick question for you:I'm looking at merge replication in Sql2000 at the moment and I have found that you can't change the schema an a published database without removing the subscribers and then removing the publication first. After the schema change the whole publiishing process ...
494 byte By
Gravy at 2008-2-5
I'm really sorry if this is too OT but it is related to replication...I have a large VB6 app that uses a Sql database that uses integer identities for primary keys. I now want to replicate this database across sites. I have played around with ranged identities but I'm also considering ...
1085 byte By
Gravy at 2008-2-4
I'm using Merge replication on a database that was designed using integer identity columns for primary keys. When I create a publisher it's great because Sql Server will create rowguid columns for me on most of the tables; actually all but one table. The problem comes when I try and use ...
452 byte By
Gravy at 2008-2-4
As I understand replication in Sql2K the only difference in push or pull subscriptions is where the agent runs. If I wanted changes in the publisher to be sent to the subscribers immediately after the change then I thought push would be better. But, if I am equally interested in changes made at ...
638 byte By
Gravy at 2008-2-4
Hi, I'm replicating a database between two instances of Sql 2000 using Merge Replication. I have no custom resolvers at present but I'm seeing something unexpected.If I change the same record in both databases at the same time, but the changes affect different columns then I thought the ...
Hi guys,Correct me if I'm wrong. That's wat I was doing.. Try to perform a merge replication between the 2.But the following errors are wat I've got during the syncronization:Error Code: 80004005Message : RunMinor Err.: 28557Source : Microsoft SQL Server 2000 Windows CE EditionErr. Par. : ...
I need to be able to create a DTS package that imports a CSV file which is loated at URL. I.E. HTTP://www.url.com/csv/thefile.xls I tried copying the URL an pasting it in the file location when in SQL wazird but I got an error message. Please help point me to anywhere that I can find some help ...